Home › Speed up Moodle using indexes

Speed up Moodle using indexes

in

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.
 

No votes yet
Submitted by lewiscarr on Wed, 04/15/2009 - 15:51

Comments

How to

Submitted by Anonymous on 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

How to

Submitted by lewiscarr on 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.