2 ms·
My addition to the already great list: using temporary tables to serve content. Temp tables are great when you have a complex report, and breaking things up int
by IgorPartola 16y ago
My addition to the already great list: using temporary tables to serve content. Temp tables are great when you have a complex report, and breaking things up into stages gives you a performance boost (think you need to do multiple lookups against a list of users that is small but takes a long time to build). So if you generate this report at midnight via a cron job, temp tables work great. However, generating a bunch of them at once is a performance hit. Instead, use indecies or (in the worst case) caching with triggers.