Drupal Running Slow on Localhost?
Recently I had a development site set up on my local machine but the site was running so slow that it was actually painful to work with. After a bit of research I found this comment - http://drupal.org/node/348202#comment-2531300
I created a file named convert.php and dropped the following into it:
<?php
// your connection
mysql_connect("localhost","db_username","db_password");
mysql_select_db("db_name");
// convert code
$res = mysql_query("SHOW TABLES");
while ($row = mysql_fetch_array($res))
{
foreach ($row as $key => $table)
{
mysql_query("ALTER TABLE " . $table . " ENGINE=MyISAM");
echo $key . " => " . $table . " set to MyISAM<br />";
}
}
?>Then I simply called the file from my browser.
This was a HUGE help.