On Fri, Jan 30, 2009 at 9:32 AM, lance raymond <lance.raym...@gmail.com> wrote: > basically I have an old fc5 machine running mysql 4.1 and a > newer server running centos5 / mysql 5.0.45.
So, different hardware, different OS, different database server... could be anything. I suggest you run EXPLAIN plans for the slow queries on both servers and compare them. The most likely reasons for a difference that large are missing indexes or vastly different filesystem performance. - Perrin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org