databases

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