Slow Query Speeds

[sbowman]

I have a database that I was using for Monthly Statistics. I've
recently loaded hundreds of thousands of records of historical data.
Now my queries are running really slow!! Is there anything I can do??

Thanks!
Shelley

[Tom Brown]

The first thing you might try is compacting the database. This should help
make the query somewhat faster.

"sbowman" <sh************@carefirst.comwrote in message
news:11**********************@m7g2000cwm.googlegro ups.com...

I have a database that I was using for Monthly Statistics. I've
recently loaded hundreds of thousands of records of historical data.
Now my queries are running really slow!! Is there anything I can do??

Thanks!
Shelley

[pietlinden]

Tom Brown wrote:

The first thing you might try is compacting the database. This should help
make the query somewhat faster.

"sbowman" <sh************@carefirst.comwrote in message
news:11**********************@m7g2000cwm.googlegro ups.com...

I have a database that I was using for Monthly Statistics. I've
recently loaded hundreds of thousands of records of historical data.
Now my queries are running really slow!! Is there anything I can do??

Thanks!
Shelley

Index the fields you search a lot too..

[Smartin]

sbowman wrote:

I have a database that I was using for Monthly Statistics. I've
recently loaded hundreds of thousands of records of historical data.
Now my queries are running really slow!! Is there anything I can do??

Thanks!
Shelley

Show us an example of a slow query. A lot depends on what you are doing
in there...

--
Smartin