[rt-users] Have their been changes in any Indexes between 3.8.4 and 3.8.8?

[Josh Narins]

I'm converting a 2.0.15 RT system with mysql to 3.8.8 using Kai's scripts.[1]

For performance reasons, he drops the indices before the insert, then recreates them after. All perfectly logical, but his scripts were based on 3.8.4

I wanted to make sure that no indices had changed between 3.8.4 and 3.8.8 so that the index recreation works as expected.

Thanks in advance:

CREATE INDEX Attachments1 ON Attachments (Parent) ;
CREATE INDEX Attachments2 ON Attachments (TransactionId) ;
CREATE INDEX Attachments3 ON Attachments (Parent, TransactionId) ;
CREATE INDEX Links4 ON Links(Type,LocalBase);
CREATE INDEX Principals2 ON Principals (ObjectId);
CREATE INDEX Groups2 On Groups  (lower(Type), lower(Domain), Instance);
CREATE INDEX Transactions1 ON Transactions (ObjectType, ObjectId);
CREATE INDEX  ACL1 on ACL(ObjectId, ObjectType);
CREATE INDEX  ACL2 ON ACL(PrincipalId, PrincipalType);
CREATE INDEX  ACL3 ON ACL(RightName);
CREATE INDEX CachedGroupMembers2 on CachedGroupMembers (MemberId);
CREATE INDEX CachedGroupMembers3 on CachedGroupMembers (GroupId);
CREATE INDEX DisGrouMem  on CachedGroupMembers (GroupId,MemberId,Disabled);
CREATE INDEX Users3 ON Users (lower(EmailAddress));
CREATE INDEX Users4 ON Users (EmailAddress);
CREATE INDEX Tickets1 ON Tickets (Queue, Status) ;
CREATE INDEX Tickets2 ON Tickets (Owner) ;
CREATE INDEX Tickets3 ON Tickets (EffectiveId) ;
CREATE INDEX Tickets4 ON Tickets (id, Status) ;
CREATE INDEX Tickets5 ON Tickets (id, EffectiveId) ;
CREATE INDEX ObjectCustomFieldValues1 ON ObjectCustomFieldValues (CustomField,ObjectType,ObjectId,Content);
CREATE INDEX ObjectCustomFieldValues2 ON ObjectCustomFieldValues (CustomField,ObjectType,ObjectId);
CREATE INDEX CustomFieldValues1 ON CustomFieldValues (CustomField);
CREATE INDEX Attributes1 on Attributes(Name);
CREATE INDEX Attributes2 on Attributes(ObjectType, ObjectId);



[1] - http://bonsai.xs4all.nl/cgi-bin/gitweb.cgi?p=rt-migration.git


Josh Narins

Director of Application Development
SeniorBridge
845 Third Ave
7th Floor
New York, NY 10022
Tel: (212) 994-6194
Fax: (212) 994-4260
Mobile: (917) 488-6248
jnarins at seniorbridge.com
seniorbridge.com<http://www.seniorbridge.com/>

[http://www.seniorbridge.com/images/seniorbridgedisclaimerTAG.gif]

________________________________
SeniorBridge Statement of Confidentiality: The contents of this email message are intended for the exclusive use of the addressee(s) and may contain confidential or privileged information. Any dissemination, distribution or copying of this email by an unintended or mistaken recipient is strictly prohibited. In said event, kindly reply to the sender and destroy all entries of this message and any attachments from your system. Thank you.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20101001/b8fb73d1/attachment.htm>