Impact of RAM on running queries in a multi user environment.

S

Sparling

We cannot get a straight answer as to how best to configure hardware
specifications in order to maximize performance of large complex multi-user
databases in order to delay conversion to SQL. For instance, with a pentium 4
Processor 2.80 GHZ are there significant advantages of 2GB of SDRam versus
512MB? These answers are very important to us.
 
S

Sylvain Lafontaine

If these answers are important to you then you should ask someone
knowledgeable in the field to take a deep look at your installation.

However, if you want a wild guess based on no other purpose than feeding
this thread then I would say that if you are accessing your databases with
Citrix/TS, the answer is probably yes but if not then it's no.

Of course, if by « Pentium 4 2.8 GHz with 512MB of RAM vs 2GB », your intent
is to designate one of the user's installations and not the server's
installation, then the answer is probably a little no in all cases.
 
T

Tony Toews

Sparling said:
We cannot get a straight answer as to how best to configure hardware
specifications in order to maximize performance of large complex multi-user
databases in order to delay conversion to SQL. For instance, with a pentium 4
Processor 2.80 GHZ are there significant advantages of 2GB of SDRam versus
512MB? These answers are very important to us.
Click to expand...

Assuming that the RAM is not over committed then it won't make a
difference. This is the Task Manager looking at the Commit Charge vs
Physical Memory.

Reviewing of indexing would be the next place to look. Including
indexing of data and boolean fields involved in search criteria.

Also, if you can live with day old data, consider creating a database
containing denormalized data on a nightly basis.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Top