[Rt-devel] Question about Type column in table Tickets

Jesse Vincent jesse at bestpractical.com
Fri Jun 24 10:40:02 EDT 2005

On Fri, Jun 24, 2005 at 09:28:41AM +0200, Joop van de Wege wrote:
> The problem is in this line:
>    AND ((main.TYPE = 'ticket'))
> I made several extra indices among them one on Ticket.Type. This turns
> out to be not neccesary since there is only one Type, 'ticket' and thus
> causes a full table scan against all Tickets ;-((
> Eliminating that line gives me reasonable query times, around 5sec.
> Now the question:
> Are there gonna be other types in the ticket table?
> If NO then this line can be removed, if YES can it be disabled until the
> time that there are other types in the ticket table?

Well, various things, such as the approvals system _do_ add other ticket
types now. (Also, RT 3.5's reminders system and the RT-Todo extension)

> Joop
> -- 
> Joop van de Wege <JoopvandeWege at mococo.nl>
> _______________________________________________
> Rt-devel mailing list
> Rt-devel at lists.bestpractical.com
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-devel


More information about the Rt-devel mailing list