[rt-devel] index for Tickets.Subject column
falcone at bestpractical.com
Wed Apr 16 15:13:21 EDT 2014
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.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Size: 235 bytes
Desc: not available
More information about the rt-devel