Bonjour Arnaud, --- Arnaud <[EMAIL PROTECTED]> wrote: > On 15 Jul 2004 at 6:27, Patrick Drouin > Your indexes look good, but I see that you have some > varchar fields. > Maybe > you could run an "optimize table" on these tables?
I'm running it at the moment, I will follow-up on the list when it's done. It could take a while I guess. > Also, you are > talking > about a 40M rows table. If it is a read only MyISAM > table, I might > try > compression. It's mainly read-only, I sometimes batch load some data but users don't update at all. I'll look into compression and see what it is about. Thanks, Patrick __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]