Don't tell me - you upgraded a PIII server to a PIV server? The cache on the PIV is les than half the size of a PIII.
We've hit this problem with our own apps that by the way they operate cache a lot of data. A PIII 1.4GHz will match a 2.4 GHz PIV.
Yes, MySQL code is written with a lot of care to use the CPU cache efficiently. Having a larger cache will compensate for the lack of CPU speed to a great extent. So the results do look about right.
-- Sasha Pachev Create online surveys at http://www.surveyz.com/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]