Ticket #25 (closed defect: fixed)

Opened 5 years ago

Last modified 4 years ago

Mysql needs more indexes

Reported by: bob Owned by: dom
Priority: major Milestone:
Component: wiki-toolkit Version: svn
Keywords: hackfestsummer2007-reviewed Cc:

Description

wiki::toolkit::setup:mysql is missing an index that wiki::toolkit::setup:pg has.

CREATE UNIQUE INDEX node_name ON node (name) this syntax should work on mysql 5(and 4 i think) also it could be done in the create table statement if need be. this really does affect performance. at least one openguide has suffered because of this.

Attachments

mysql_index.patch Download (382 bytes) - added by bob 5 years ago.
a patch for indexes

Change History

Changed 5 years ago by bob

a patch for indexes

Changed 5 years ago by dom

  • owner changed from dom to Nobody

Changed 5 years ago by Kake

  • keywords hackfestsummer2007-reviewed added

Decision: We need to make sure it works with upgrades, and bump schema version.

Either Nick or Dom will do this (Dom to talk to Nick).

Changed 4 years ago by dom

  • owner changed from Nobody to dom
  • status changed from new to assigned

Changed 4 years ago by dom

This depends on #32.

Changed 4 years ago by dom

This applies to the SQLite support too.

Changed 4 years ago by dom

Note to self: implemented in working copy.

Changed 4 years ago by dom

  • status changed from assigned to closed
  • resolution set to fixed

(In [441]) Move to new schema version 10, including some missing indexes and support for deletion flags and verified flags. Note that the code using these columns has not yet been written (closes #25, #34).

Note: See TracTickets for help on using tickets.