Slow Queries

J

Joe Williams

I have an application that has several queries run against large tables. In
the past these queries have taken sometimes up to 30 seconds or so.

Now I am experiencing where these same queries are taking over 5 minutes,
and sometimes they take so long that I have to CTL-BREAK and just give up.

What could be the cuase and where do I start in debugging why these queries
are taking so long?
 
J

John Vinson

I have an application that has several queries run against large tables. In
the past these queries have taken sometimes up to 30 seconds or so.

Now I am experiencing where these same queries are taking over 5 minutes,
and sometimes they take so long that I have to CTL-BREAK and just give up.

What could be the cuase and where do I start in debugging why these queries
are taking so long?
Click to expand...

Take a look at Tony's excellent performance FAQ:

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


John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
J

Joe Williams

Does the size of an MDB have anything to do with the performance of it? My
MDB is about 50MB, with about 60 linked tables, around 100 queries or so,
100 forms, 100 reports, etc.

If so, how can I correct the issue?
 
T

Tony Toews

Joe Williams said:
I have an application that has several queries run against large tables. In
the past these queries have taken sometimes up to 30 seconds or so.

Now I am experiencing where these same queries are taking over 5 minutes,
and sometimes they take so long that I have to CTL-BREAK and just give up.
Click to expand...

Do they have some function calls? Those can slow things down. Also
right joins.

You may have better luck posting your query in the m.p.access.queries
newsgroup.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Top