Features / Usability

Posted by tibi 16 Oct 2006 15:01 GMT-0000 posts: 61

thanks al123 finaly i don't feel so lonly anymore. i will use our tips!

in java i have writen a small program which reads the logged queries from above and runs them agains the database with explain.
this gave me a nice overview of missing indexes.
up to now i found these:

ALTER TABLE `ijbrug`.`tiki_articles` ADD INDEX `topicId` USING BTREE(`topicId`);
ALTER TABLE `ijbrug`.`users_permissions` ADD INDEX `type` USING BTREE(`type`);
ALTER TABLE `ijbrug`.`tiki_forum_attachments` ADD INDEX `threadId` USING BTREE(`threadId`);
ALTER TABLE `ijbrug`.`users_users` ADD INDEX `login` USING BTREE(`login`);
ALTER TABLE `ijbrug`.`tiki_modules` ADD INDEX `name` USING BTREE(`name`);
ALTER TABLE `ijbrug`.`tiki_user_assigned_modules` ADD INDEX `position` USING BTREE(`position`);
ALTER TABLE `ijbrug`.`tiki_articles` ADD INDEX `publishDate` USING BTREE(`publishDate`);
ALTER TABLE `ijbrug`.`tiki_articles` ADD INDEX `expireDate` USING BTREE(`expireDate`);
ALTER TABLE `ijbrug`.`tiki_articles` ADD INDEX `type` USING BTREE(`type`);
ALTER TABLE `ijbrug`.`tiki_article_types` ADD INDEX `show_pre_publ` USING BTREE(`show_pre_publ`);
ALTER TABLE `ijbrug`.`tiki_article_types` ADD INDEX `show_post_expire` USING BTREE(`show_post_expire`);