Slow Count/Sum Queries

[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!!!

 

[Guest]

have you tried compact and repair DB to shrink it? That sounds pretty large.
(e-mail address removed)

 

[HSalim]

What sort of indexes do you have on the tables?
Indexes are vital to aggregate queries

HS

 

[James D Carroll]

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