Use DB indexes
Indexes or indices? If this was anything but an article on databases I’d use indices. Anyway, XHTML Friends was taking about 3 minutes to load a page. I added three indexes to two tables and now it takes a few seconds. I have never seen such a speed increase come from adding indexes to a database. So let this be a lesson to me…