Performance

  • Thread starter Thread starter gr
  • Start date Start date
G

gr

Hi, I have a very slow query but still acceptable. Until
now the database has a very few records (no more than 50).
How does the opening time of my query will be affected
while the database grows? I expect that the database will
grow every month about 6000 records and will be used by
approx 20 users.
So, what I don't know if is this waiting time is because
of the query definition itself or it's also content
related.

thx.
 
It is difficult to say whether the performance issue you raise is due to the
way your query is written or to any other issue. You could open
Tools|Analyze|Performance and run that on your query to see if it can be
optimized.

In addition, there are often other issues that will affect your database
performance. Access MVP Tony Toews has collected and published these at:

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