Solved for real this time. Turns out that 4.0.16 wasn't using the same indexes in the table as the older 4.0.14, so the newer version was using "filesort" instead of indexes, causing the massive slowdown. Reverting back to 4.0.14 and everything went back to full speed. I have no idea why mysql would not using the indexes the same database, but I'm happy to have things back up at 100% :)
alan -- Alan <[EMAIL PROTECTED]> - http://arcterex.net -------------------------------------------------------------------- "There are only 3 real sports: bull-fighting, car racing and mountain climbing. All the others are mere games." -- Hemingway -- [EMAIL PROTECTED] mailing list
