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]

Re: Slow Query Speeds

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

"sbowman" <shelley.bowman @carefirst.comw rote in message
news:1161291963 .206362.259840@ m7g2000cwm.goog legroups.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@hotmail.com]

Re: Slow Query Speeds


Tom Brown wrote:

The first thing you might try is compacting the database. This should help
make the query somewhat faster.
>
"sbowman" <shelley.bowman @carefirst.comw rote in message
news:1161291963 .206362.259840@ m7g2000cwm.goog legroups.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]

Re: Slow Query Speeds

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