[rt-users] RT speed problem

[Vivek Khera]

>>>>> "DN" == Darren Nickerson <darren at dazza.org> writes:

>>>>> On Thu, 7 Feb 2002, "Vivek" == Vivek Khera wrote:

Vivek> Or, do it the easy way: diff the schema files between older and newer
Vivek> release and add the necessary indexes.

DN> Easy for YOU perhaps. I started out that way, . . . but the diffs
DN> were huge and hard to interpret because of all of other stuff that

The entire diff from 2.0.7 to 2.0.11 for Postgres is this.  Three
fields changed size, and a bunch of new indexes added (one was
renamed, which is immeterial).

The diff to the mysql schema is pretty much identical.  Just run the
CREATE INDEX commands and you're all set.



> CREATE INDEX Attachments3 ON Attachments (Parent, TransactionId);
34c35
<   Name varchar(40) NOT NULL  ,
---
>   Name varchar(120) NOT NULL  ,
36,37c37,38
<   CorrespondAddress varchar(40)   ,
<   CommentAddress varchar(40)   ,
---
>   CorrespondAddress varchar(120)   ,
>   CommentAddress varchar(120)   ,
137c138,139
< CREATE INDEX ACL1 ON ACL (RightScope, RightAppliesTo, RightName, PrincipalType, PrincipalId);
---
> CREATE INDEX ACL1 ON ACL (RightScope, PrincipalId);
> CREATE INDEX ACL2 ON ACL (RightScope, RightAppliesTo, RightName, PrincipalType, PrincipalId);
205c207,209
< CREATE INDEX Users2 ON Users (EmailAddress);
---
> CREATE INDEX Users2 ON Users (Name);
> CREATE INDEX Users3 ON Users (id, EmailAddress);
> CREATE INDEX Users4 ON Users (EmailAddress);
236a241
> CREATE INDEX Tickets5 ON Tickets (id, EffectiveId);