Database Split - Big Performance Hit

  • Thread starter Thread starter Leif
  • Start date Start date
L

Leif

I've tried splitting my database and I'm seeing a dramatic
performance hit. My database is 14MB as one MDB and
4/10MB FE/FB after split. The following are for bring up
a moderately complex form the first time. Here are the
stats:

My local machine:

Non-split 2 seconds
Split 30 seconds

Network:
Non-split 2 seconds
Split, both on network 6 minutes and 30 seconds
Split, FE local 5 minutes and 40 seconds

However, it seems the second time I call up the same form
its only a few seconds.

Anynoe have an idea whats wrong?
 
Hi Lief

Tony Toews has an Access Performance FAQ that will sort this out for you:
http://www.granite.ab.ca/access/performancefaq.htm

The most crucial items are:
1. Keep the fully qualified path name to the back end down to 128
characters.

2. Turn off Name AutoCorrect.

3. Disable Subdatasheets.


If your workstation is running WinXP, check out this new article also:
Your access to network resources is slower in Windows XP
at:
http://support.microsoft.com/?id=834350
 
I owe Tony big time for this!
Just to add that in my experience, the persistent recordset is also a major
improvement driver.

Nikos
 
Nikos Yannacopoulos said:
I owe Tony big time for this!
Just to add that in my experience, the persistent recordset is also a major
improvement driver.
Click to expand...

(snip)

Doesn't need a recordset.

set db = dbengine.opendatabase ("path to BE db")

works fine.

TC
 
Back
Top