split database degraded performance

[Guest]

Hi

I have split a database and the result concerning speed is disappointing. It
takes about ten times more to answer a query or even to open a form.
That happens even if both the back end and front end files are located in
the same physical drive.
Is it normal when splitting a database, or is something wrong to my
application?

regards

GL

 

[Albert D.Kallal]

As a general rule, I have not seen the slow down when both files are split,
and on your same drive.

However, in general, to restore performance, you need to keep a persistent
connection opened AT ALL TIMES from the front end, to the back end.

So, in your startup code, open up a reocrdset and keep it open. Or you can
simply open up a form attached to a back end table and minimize it. (or,
even make it invisible if you do this in code). By forcing the connection
to stay open, you eliminate the file open delays that are very nasty.

Do the above, and performance will return to normal....

You can read above the above trick, and a few more things to check here:

http://www.granite.ab.ca/access/performancefaq.htm

Another problem with linked tables is that you want to turn off the sub
datasheet options. Again, the above check list has all the things to
check...