On 15 Jul 2004 at 6:27, Patrick Drouin <[EMAIL PROTECTED]> wrote: > I'm having a hard time with the following query. It > retrieves about 3K rows from a few tables. One of them > contains over 40M rows. When run on a 3Ghz server with > 1G of RAM it returns the rows in more than 1 mini. I > don't think that's normal.
Your indexes look good, but I see that you have some varchar fields. Maybe you could run an "optimize table" on these tables? Also, you are talking about a 40M rows table. If it is a read only MyISAM table, I might try compression. Arnaud -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]