I have a few intolerably slow queries and I'm hoping some of you might
have some additional query speed-up tricks to share...
My limited bag of tricks:
* Examine EXPLAIN output to eliminate sequential scans;
* Make sure all lookup columns have indices;
* Use strictly integer primary/foreign keys;
* Avoid using 'IN';
* Use the -F flag;
* Regular vacuuming, of course...
What works for you folks?
Regards,
Ed Loehr
