News for hackers. Stuff that matters.
Re:Database development mistakes made by application developers by IgorPartola on Monday December 13, 2010 @08:11AM (#2000337)
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.

There are no comments on this comment yet.