[Rt-devel] SQL/DBI caching

[Alex Pilosov]

On Mon, 6 Jul 2009, Jesse Vincent wrote:

> 
> 
> > Well, so far, I've found that SearchBuilder will not do negative
> > result caching (as in, if there's no entry for a certain query, it
> > will keep re-querying repeatedly). Fixing that went from 120 queries
> > to 80.
> 
> What queries were you seeing here?
The repeated query is:

SELECT  * FROM Attributes WHERE LOWER(ObjectType) = LOWER(?) AND LOWER(Name) = LOWER(?) AND ObjectId = ?'

With parameters: 35  /  ShowTicket  /  RT::System-1 

> What happens if you turn on $UseSQLForACLChecks in your
> RT_SiteConfig.pm?
Will try.