Here's a MySQL tip: run EXPLAIN on puzzling queries, then rewrite them for efficiency. I cache frequent results where safe, and tune the joins so data flows smoothly rather than tripping over itself.
created using Blast-Me.com