SQL Performance improvement

[GoogleCodeExporter]

Hi,

I analyze index usage of clip bucket and there are some queries which are run 
on each and every request without index therefore my suggestion for perfomance 
improvement is to add following indexes into standard SQL structure

ALTER TABLE  `cb_plugins` ADD INDEX (  `plugin_active` );
ALTER TABLE  `cb_sessions` ADD INDEX (  `session` );
ALTER TABLE  `cb_languages` ADD INDEX (  `language_default` );
ALTER TABLE  `cb_conversion_queue` ADD INDEX (  `cqueue_conversion` );
ALTER TABLE  `cb_video` ADD INDEX (  `status`,`active`,`broadcast`,`userid` );
ALTER TABLE  `cb_user_levels_permissions` ADD INDEX (  `user_level_id` );
ALTER TABLE  `cb_video` ADD INDEX (  `userid` );
ALTER TABLE  `cb_users` ADD INDEX (  `username`(255),`userid` );
ALTER TABLE  `cb_pages` ADD INDEX (  `active`,`display` );
ALTER TABLE  `cb_video` ADD INDEX (  `videoid`,`videokey`(255) );
ALTER TABLE  `cb_languages` ADD INDEX (  `language_code`,`language_id` );
ALTER TABLE  `cb_video_categories` ADD INDEX (  `parent_id` );

Jozef

Original issue reported on code.google.com by j...@jozo.sk on 24 Apr 2012 at 12:30

[GoogleCodeExporter]

Original comment by zomail...@gmail.com on 6 May 2013 at 11:47

• Changed state: Accepted

[GoogleCodeExporter]

Thanks very much for your analyze. I've applied modifications on my website and 
it go really faster now.

D.

Original comment by didier.s...@gmail.com on 27 Sep 2013 at 8:36

[GoogleCodeExporter]

Thanks, its now part of our ClipBucket source code.

Original comment by arslan...@gmail.com on 25 Feb 2015 at 3:11

• Changed state: Verified