Database Split - Big Performance Hit

[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?

 

[gr]

Hello,
Yes splitting the database may affect performance. But
follow the tips in the following link to improve it.
http://www.granite.ab.ca/access/performancefaq.htm

hth,
gr

 

[Allen Browne]

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

 

[Nikos Yannacopoulos]

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

Nikos

 

[TC]

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

(snip)

Doesn't need a recordset.

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

works fine.

TC