For what its worth, I believe this is a big performance hit on RT 3.6.x too, so I'd recommend fixing rather than downgrading. :)
I witnessed this query with a high execution rate on RT 3.6.1. On 17/07/2008, at 1:28 PM, Jessie Bryan wrote: > Update- > > Ok, after several hours of logging, what I see most common in the slow > query (1s) log is: > > LOG: duration: 3151.786 ms statement: EXECUTE <unnamed> [PREPARE: > SELECT * FROM Groups WHERE LOWER(Domain) = LOWER($1) AND LOWER(Type) > = LOWER($2)] > > Several hundred of these queries in the slow query log data. _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
