Upgrade to php 5. Optimizing MySQL 4.1.2

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
loveccb
Forum Newbie
Posts: 10
Joined: Wed Jul 05, 2006 6:48 pm

Upgrade to php 5. Optimizing MySQL 4.1.2

Post 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!
User avatar
RobertGonzalez
Site Administrator
Posts: 14293
Joined: Tue Sep 09, 2003 6:04 pm
Location: Fremont, CA, USA

Post 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.
Post Reply