[rt-users] 2.0.9 bogs with >10K tickets

[Chris Scott]

Here's what I have from an old email to the list:


alter table Transactions ADD INDEX TicketIndex(Ticket);
alter table Transactions ADD INDEX EffectiveTicketIndex(EffectiveTicket);
alter table Transactions ADD INDEX CreatorIndex(Creator);
alter table Attachments ADD INDEX CreatorIndex(Creator);
alter table Attachments add index ParentIndex(Parent);
alter table Attachments ADD INDEX TransactionId(TransactionId);
alter table Tickets ADD INDEX EffectiveIdIndex(EffectiveId);
alter table Tickets ADD INDEX OwnerIndex(Owner);
alter table Tickets ADD INDEX CreatorIndex(Creator);


Hope this helps.
--
Chris Scott
Host Orlando, Inc.
http://www.hostorlando.com/
407-622-8955 


> -----Original Message-----
> From: rt-users-admin at lists.fsck.com
> [mailto:rt-users-admin at lists.fsck.com]On Behalf Of Darren Nickerson
> Sent: Thursday, December 20, 2001 12:28 PM
> To: Steve Poirier
> Cc: rt-users at lists.fsck.com
> Subject: Re: [rt-users] 2.0.9 bogs with >10K tickets 
> 
> 
> 
> >>>>> On Thu, 20 Dec 2001, "Steve" == Steve Poirier wrote:
> 
>   Steve> Hi Darren,
> 
>   Steve> Check at archive there are some posts on indexes you can 
> apply to your
>   Steve> db which greatly improves performance if you hardware is 
> suitable for
>   Steve> the operations of your box. 10,000 tickets is relativaly 
> small for a
>   Steve> MySQL database considering the schema of the archive.
> 
> Thanks Steve, I DID check the archives before bothering the list 
> and I thought
> I only saw posts which referred to the 1.x release series of RT. 
> I has assumed
> that 2.0.9 would have included much of that.
> 
> I'll take a closer look.
> 
> -Darren
> 
> 
> 
> _______________________________________________
> rt-users mailing list
> rt-users at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-users
> 
>