Here’s a noob-to-noob optimization trick. Suppose you have a database table with, say, 200,000 records, and you regularly select on multiple criteria. The rule for selection is to put the most specific WHERE clause first, and the least specific last. The goal is to cut down the search set to something small, and then search through the smaller set. Get all the queries using this order, then create a composite index over the keys to speed up the search even more. Continue reading Help Speed Up a MySQL Query by Helping the Optimizer
I describe how others page over results, and how I do it.
I find fascinating URIs that looks like this:
http://mysite.com/index.php?page=3&search=foo Continue reading Paginating Database Results