Slow Count/Sum Queries

  • Thread starter Thread starter James D Carroll
  • Start date Start date
J

James D Carroll

I have an Access 97 (no service packs) database that's 114 megs. The three
tables of interest are from 30K-50K rows and are being "JOIN" 'ed . The DB
is on a network drive.

When we run a regular 'Select *' query the return takes maybe 15 seconds.
When we run a Count(*) or Sum(field) query though the wait is MUCH MUCH
longer.

Any ideas. If you need more info let me know.

THANKS!!!
 
have you tried compact and repair DB to shrink it? That sounds pretty large.
(e-mail address removed)
 
What sort of indexes do you have on the tables?
Indexes are vital to aggregate queries

HS
 
In answer to both, one of the problems is that the thing is used all day and
you can't create an index or compact/repair while the ldb file is there. I'm
gonna sneak tommorrow when no one else is there and do both. I agree that a
well placed index may help. Hopefully ALOT. You have no idea how slow this
thing. : )

Thanks for the ideas
 
Back
Top