Here’s a piece of trivia for y’all while I wait for a long-running task to complete: if you have a web page (using ASP) execute a query against a remote MySQL database, and if that query happens to include a text comparison, and if the column you’re comparing against doesn’t happen to be indexed, and you happen to have nearly 6 million records in the table, well, you’ll basically fry both servers. The webserver should probably be better configured to not lose the ASP process when one page does a dumb thing, but more importantly, this is probably a good lesson in testing your queries against full-scale data sets before promoting to production (thankfully, we’re still in dev)
Ah. Index built, 10 minutes, 17.22 seconds later. Back at it, then.
Post a Comment