Speed up program

  • Thread starter Thread starter Curt
  • Start date Start date
C

Curt

I have a program that I placed the BE on a server. I
also, have about 10 computers that I placed the FE on.
For some reason there is lag time 5-10 sec when trying to
open some of the forms. This is even done when I just use
both the FE and BE on one machine. Does anyone know of a
way of how to speed up the process of opening these
forms. Each one has a query in the background and yes
some of these share some of the same information. I have
read different web sites on how so solve this, but without
any luck. For right now we only have about 100 records
and expect it to grow to about 10,000 I really don't want
to see the lag grow due to that amount of records.

Any adive would be appreciated.
 
Curt said:
I have a program that I placed the BE on a server. I
also, have about 10 computers that I placed the FE on.
For some reason there is lag time 5-10 sec when trying to
open some of the forms. This is even done when I just use
both the FE and BE on one machine. Does anyone know of a
way of how to speed up the process of opening these
forms. Each one has a query in the background and yes
some of these share some of the same information. I have
read different web sites on how so solve this, but without
any luck. For right now we only have about 100 records
and expect it to grow to about 10,000 I really don't want
to see the lag grow due to that amount of records.

Any adive would be appreciated.
Click to expand...

If both FE and BE are on the same machine, one would not think the
network has anything to do with it. Still, if you haven't read Tony
Toews' Access Performance FAQ, you should:

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

Another thing to check, if you're using Access 2000 or later, is the
Name AutoCorrect option (Tools -> Options..., General tab, "Track name
AutoCorrect info"). Turn that option off and see if it makes any
difference.
 
10,000, or even files of 50,000 records will work just fine across a typical
office network.

So, if you can fix the performance problem...then you should be just fine in
terms of size, number users, network load etc.

The first thing is to check Tony's list at:

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

The other thing is to always distribute a mde to your users (the forces the
code to stay compiled).

And, the trick of keeping a persistent connection open to the back end also
is the about #1 thing you can do (that means keeping a table opened from the
front end that resides in the back end...any table will do).
 
Thanks I read is web site. I did your second suggestion
and it corrected it fine. Thanks for the info.
 
Back
Top