[rt-devel] index for Tickets.Subject column

[Kevin Falcone]

On Tue, Apr 15, 2014 at 07:48:00AM +0200, Christian Loos wrote:
> as we have with RT 4.2 ticket links autocomplete, which use by default
> the tickets subject, shouldn't there be an index on that column?

It won't help in the default though, since we do Subject LIKE '%foo%'.
If you switched in the config to a Subject => STARTSWITH then we would
generate Subject LIKE 'foo%' which mysql/pg at least can actually use an
index for (tested briefly on a mysql 5.5 and pg 9.2).

Sounds like a doc patch suggesting this if link autocompleting is slow
would be good, but I don't think we should add the index if it isn't
going to help the default case.

-kevin
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 235 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-devel/attachments/20140416/bea411ae/attachment.pgp>