[rt-users] Indicies to add to RT3

[Brent Wiese]

To this point, are there a list of default indexes anywhere?

With how slow my system seems to run (a display ticket takes about 10
seconds), I'm wondering if I'm just missing some of the default indexes.

Unfortunately, I don't have a great knowledge of mysql, so not even sure how
to check my current DB...


> I'm hoping some people will share the indexes they've added 
> to make their install of RT3 run faster.
> 
> I'll start: In order to speed searches on custom fields we 
> just added an index to the TicketCustomFieldValues table. 
> This made the search time go from over 10 minutes to under 
> half a second. We have 8500 tickets and 12,500 
> TicketCustomFieldValues.
> 
> The command I used was: 'alter table TicketCustomFieldValues 
> add index (Ticket);'
> 
> Matt Simonsen
> 
> _______________________________________________
> rt-users mailing list
> rt-users at lists.fsck.com 
> http://lists.fsck.com/mailman/listinfo/rt-users
> 
> Have you 
> read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm
> 
>