Can Access 2000 use a dual processor pc

  • Thread starter Thread starter Howard
  • Start date Start date
H

Howard

Does Access 2000 have multithreading capabilities? Would it benefit
from a dual processor pc? I know disk I/O is also very important, but
I'm interested in the processor portion of it.

Thanks!
 
No, it likely will not benefit much. However, it is written using standard
windows development tools, and some threading might occur.

On the other hand, running ms-access on a old notebook at 600 Mhz, ms-access
can execute around 25 MILLION instructions per second. That is on a old 600
mhz notebook!

It has been years since I seen any ms-access application be EVEN REMOTELY
close to being processor limited. And I am talking about a 600mhz pc,a nd
today, we are many times faster yet again.

So, even if ms-access COULD USE multithreading, it would be fluke, and a
cold day in hell that you would EVER NOTICE ANY BENEFIT from this feature
anyway!

So, no, ms-access does not using multi threading, and it could not
possibility matter for 99.99% of appcltions in ms-access anyway.

While ms-access can perform those 25 milling instructions per second, it is
the disk drive, and the network are going to be the bottle neck...and NOT
ms-access. Ms-access just spends most of its time wating for things!
 
The Access database engine (Jet) is multi-threaded.
By default it uses three threads, but this can be
increased by a registry setting. Threads are used
for background processes, like loading or flushing
the data cache.

However, Access is not certified for use on a dual
processor pc, and perhaps never will be. You will
probably get thread contention issues if you try.

You might be able to get around the (hypothetical)
thread contention issues (perhaps by turning off
one of the processors), but that would probably
defeat the theoretical advantages.

Although MS does no further development of Jet, they
continue to release bug fixes. Intel is selling a
'hyperthread' processor, which works like a dual
processor. If enough people use these, perhaps MS
will fix Jet so that it is safe to use on a multi-
processor system.

(david)



Howard said:
Does Access 2000 have multithreading capabilities? Would it benefit
from a dual processor pc? I know disk I/O is also very important, but
I'm interested in the processor portion of it.

Thanks!
Click to expand...
 
Back
Top