[Rt-devel] SQL/DBI caching
alex at pilosoft.com
Mon Jul 6 10:19:55 EDT 2009
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
More information about the Rt-devel