Opened 13 years ago

Closed 11 years ago

#25 closed defect (fixed)

Mysql needs more indexes

Reported by: bob Owned by: Dominic Hargreaves
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 (1)

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

Download all attachments as: .zip

Change History (8)

Changed 12 years ago by bob

Attachment: mysql_index.patch added

a patch for indexes

comment:1 Changed 12 years ago by Dominic Hargreaves

Owner: changed from Dominic Hargreaves to Nobody

comment:2 Changed 12 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).

comment:3 Changed 12 years ago by Dominic Hargreaves

Owner: changed from Nobody to Dominic Hargreaves
Status: newassigned

comment:4 Changed 12 years ago by Dominic Hargreaves

This depends on #32.

comment:5 Changed 11 years ago by Dominic Hargreaves

This applies to the SQLite support too.

comment:6 Changed 11 years ago by Dominic Hargreaves

Note to self: implemented in working copy.

comment:7 Changed 11 years ago by Dominic Hargreaves

Resolution: fixed
Status: assignedclosed

(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.