> Please don't hijack threads. Sorry - did a reply-all to get the address set up; changed the subject but was working on a few emails at the same time (also posting to the Postgres newsgroup - their version of the query, on the same machine (with MySQL stopped) takes 19 seconds with incorrect statistics, and 41 seconds after a "vacuum analyze" to get the statistics set up), copying and pasting from windows. Forgot to clear out the original message.
> What does an EXPLAIN SELECT .. on both queries print? LEFT JOINs > definitely impose a table order, and it's possible MySQL is incorrectly > ordering other joins on those tables. You didn't mention what version > of MySQL you are using, btw. Using 4.0.14 max, all tables InnoDB. I think the problem was that I hadn't analyzed the tables. Once I did that for all the tables, I got a consistent speed of .20 seconds, regardless of the table ordering. David. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
