[Rt-devel] Optimizing _BuildItemMap / ItemsArrayRef in Tickets_Overlay.pm

Jesse Vincent jesse at bestpractical.com
Tue Apr 26 15:47:07 EDT 2005


> > What's your realistic test case?
> 
> Probably on the order of 1000 tickets.  That's only 4MB, but that still 
> takes time.

In most cases, your ticket searches are going to be limited to pages,
usually of 25,50 or 100 items. What's the use case you're running into
this being any sort of an issue?

> 
> > > 
> > > Can _BuildItemMap be written such that it doesn't use ItemsArrayRef and
> > > uses a custom SQL query that pulls down only the ticket ids, instead?
> > > 
> > > -- Gene
> 
> -- Gene
> 

-- 


More information about the Rt-devel mailing list