Parallel Threads or Processes Improve Application Performance?

S

Siegfried Heintze

I have a screen scraper populating my Access database. Assuming that network
latency is not the bottle neck, can I expect multiple threads or processes
populating the same access database simultaneously to populate it faster?

I thought MSAccess was single threaded and locked the entire database file
whenever there was an INSERT or UPDATE in progress and therefor having
multiple processes or threads would not improve the thru put.

Presently I have two different MSAccess database files being populated by
two different screen scrapers so the two different processes are not
competing for the same database. I am surprised to see that each process is
running as fast as it did when running solo. How could this be?

Thanks,
Siegfried
 
J

Jeff Boyce

Siegfried

I believe you have the option of setting record locking behavior, including
none. Check the Tools | Options settings.

Regards

Jeff Boyce
<MS Office/Access MVP>
 
S

Siegfried Heintze

Jeff Boyce said:
Siegfried

I believe you have the option of setting record locking behavior, including
none. Check the Tools | Options settings.

Regards
Any more hints? I'm looking at this presently.


When I'm populating the database with Perl, I have multiple screen scrapers
performing SELECTs, INSERTs, and UPDATEs. However, ASP.NET complains it
cannot lock the file when one screen scraper has the database open.

I have all the database default settings. I see "Open databases using record
level locking" is checked. Default open mode is "shared". I cannot find
anything else that looks relevant.

Thanks,
Siegfried
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top