The top complaint about the LibraryThing for Libraries was the speed of the tag browser. We revisited it today, and made it MUCH faster. It’s positively zippy!

It proved to me, yet again, that sometimes your seemingly perfect MySQL query—JOINS across five tables on primary keys and EXPLAINs like a dream—can be broken into two queries for an order-of-magnitude speed increase. If I were smarter, I’d understand this.

Labels: Uncategorized