I don't believe Access can take advantage of multi-threading.

Jet is multi-threaded. The default number of threads is 3. This
causes a problem with IIS. IIS tries to create multiple database
threads: inside the thread creation code, Jet tries to create
multiple threads. Windows thread creation code is not re-entrant,
and it crashes. Solutions are to restrict IIS to a single database
thread, use a special database method that I don't understand, or
(my idea) change the registry setting so that Jet only uses one thread.

Also, Windows can take advantage of multi-threading, and Jet uses
Windows as part of the database engine. By default, applications
run on one processor, and the OS runs on the other, so all of your
SQL would be on one processor, and all your file operations would
be on the other. Right?

(david)

"Douglas J. Steele" wrote in message
...
I don't believe Access can take advantage of multi-threading.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Niniel" wrote in message
...
Turn it into a multi-threaded application and run it on a
multi-processor
system, that should speed things up.
For true lightspeed-like speed you'll probably have to build yourself a
quantum computer.

"Anthony" wrote:

What does EVERYONE recommend I do to make my database run as close to
lightning speed as possible?