Page 1 of 1

Upgrade to php 5. Optimizing MySQL 4.1.2

Posted: Mon Nov 13, 2006 4:59 pm
by loveccb
After upgrading to php 5, I've noticed a horrible drag in SQL queries of all types. Can anyone point me to some good resources on optimization/upgrade issues to PHP 5 in relation to MySQL?

Many thanks!

Posted: Mon Nov 13, 2006 5:09 pm
by RobertGonzalez
First thing, make sure your indexes are still in place. Next, make sure table types are the same. Typically, in an upgrade of MySQL, table types end up changing from MyISAM to InnoDB. This could effect the performance of your DB.