[rt-users] Indicies to add to RT3

[Matt Simonsen]

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