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

[Jesse Vincent]

> > 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
> 

--