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.