1. 09 Nov, 2012 6 commits
    • Jérome Perrin's avatar
      Add portal_type in *_state indexs, for better performance with worklists · 46202cb4
      Jérome Perrin authored
      update script:
      
      ALTER TABLE `catalog`
      DROP INDEX `validation_state`,
      DROP INDEX `simulation_state`,
      DROP INDEX `causality_state`,
      ADD INDEX `validation_state_portal_type` (`validation_state`, `portal_type`),
      ADD INDEX `simulation_state_portal_type` (`simulation_state`, `portal_type`),
      ADD INDEX `causality_state_portal_type` (`causality_state`, `portal_type`)
      46202cb4
    • Jérome Perrin's avatar
      include portal_type in section_uid index in stock table · 8ad45c81
      Jérome Perrin authored
      To update:
      ALTER TABLE `stock` DROP INDEX section_uid, ADD INDEX `section_uid_portal_type` (`section_uid`, `portal_type`)
      8ad45c81
    • Jérome Perrin's avatar
      Use better index on translation table · 7f5d31eb
      Jérome Perrin authored
      Update with:
      ALTER TABLE `translation` DROP INDEX `portal_type`, ADD INDEX `type_translated_message` (`portal_type`,`translated_message`);
      7f5d31eb
    • Jérome Perrin's avatar
      remove useless index · 84e75fc4
      Jérome Perrin authored
      update with:
      ALTER TABLE `inventory_stock` DROP INDEX `resource_uid`; -- exists in resource_node_uid
      ALTER TABLE `stock` DROP INDEX `resource_uid`; -- exists in resource_node_uid
      84e75fc4
    • Jérome Perrin's avatar
      remove useless index · 93d86daa
      Jérome Perrin authored
      update with
      ALTER TABLE `predicate_category` DROP INDEX `FuzzyMembership`; -- exists in Membership
      93d86daa
    • Jérome Perrin's avatar
      typo in index definition · 6f5c172f
      Jérome Perrin authored
      update with:
      
      ALTER TABLE `versioning` DROP INDEX `expiration_date`;
      ALTER TABLE `versioning` ADD INDEX `expiration_date` (`expiration_date`);
      6f5c172f
  2. 08 Nov, 2012 6 commits
  3. 07 Nov, 2012 7 commits
  4. 06 Nov, 2012 4 commits
  5. 05 Nov, 2012 17 commits