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

[Jesse Vincent]

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
> 

--