Thursday September 9, 2004
Slow SQL Queries
- Posted by Rob (#1) on September 9, 2004 13:28 CEST
If your database table has 11 million records, adding a proper index will speed it up significantly, especially when you edit the query so that it can actually use the index. Accomplished performance gain at work: query times dropped from 30s to less than 0.1s, so that'd be a 30,000% gain. Wiee. Monitoring the database should include less uh-oh thoughts tomorrow morning.
- PermaLink: Slow SQL Queries
- Tags: Yarosa, SQL, databases
- Post comment