"Niniel" wrote in message
...
I know.

But can [other] SQL dbs?

Well, they might, but it actually been known for a LONG time that most
databases are not processing bound. What that means is that if you use 1, or
100 processors, you will NOT notice a speed increase in he application (even
if it was 100% threaded).

Why?

the reason for this is that the speed of your hard disk is not changed, and
is the limiting factor here. We are not processing bound in ms-access, but
in fact i/o (input/output) bound. That means the speed of your disk drive,
or network is the limiting factor. So, in fact, if you have an existing
machine, and put in a whole bunch more of processors, it not going to help.
The same applies to sql server, and often adding more processors will NOT
speed things up, since your bottle neck is reading the data from the disk
drive...and more processors don't help that.....

It is really the same thing as saying that if you purchase a new computer,
it will download things faster from the internet..and it not going to make
one bit of difference unless you speed up you internet connection....-- this
same rule applies to ms-access also...

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada