15
Apr
Speed up Moodle using indexes
Creating an index on the mdl_log table against info speeds up a standard Moodle installation. Some users have reported huge performance increases, so much so that people have suggested that this be in the standard Moodle build by default.
So far I have noticed some improvements but nothing quite as fantastic as other users are reporting, having said that, maybe you may notice a speed increase to your site, try it leave me a comment here.
Tue, 04/28/2009 - 04:07
How do you create an index on the mdl_log table?
With appreciation for your insights into speeding up Moodle,
Miguel Guhlin
Around the Corner-mGuhlin.org
http://mguhlin.org
Tue, 05/05/2009 - 09:00
You can do this graphically through PhpMyAdmin or something similar. Select the table you require and add the index. You can do it through command line but it's easier to do it visually. SQLyog is a great GUI MySQL tool. They have a community version too.