By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,952 Members | 1,937 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,952 IT Pros & Developers. It's quick & easy.

Slow Query Speeds

P: n/a
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

Oct 19 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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

Oct 19 '06 #2

P: n/a

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..

Oct 19 '06 #3

P: n/a
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
Oct 19 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.