Dear RT community, I have been trying to track down some ticket display slowdowns for our upgrade from 3.8.5 to 3.8.13+security patches. One difference in the new version is that we have the latest RT-IR installed. Now there is a noticable pause during the population of the ticket metadata right after the "The Basics" pane. When I enabled query logging in the DB (postgreSQL), I see almost 700 queries of the type:
2012-12-05 08:57:40.365 CSTLOG: duration: 0.325 ms statement: SELECT DISTINCT main.* FROM CustomFields main JOIN ObjectCustomFields ObjectCustomFields_1 ON ( ObjectCustomFields_1.CustomField = main.id ) WHERE (LOWER(main.Name) = 'constituency') AND (ObjectCustomFields_1.ObjectId = '28') AND (main.LookupType = 'RT::Queue-RT::Ticket') ORDER BY main.Disabled ASC LIMIT 1 2012-12-05 08:57:40.366 CSTLOG: duration: 0.512 ms statement: SELECT DISTINCT main.* FROM CustomFields main JOIN ObjectCustomFields ObjectCustomFields_1 ON ( ObjectCustomFields_1.CustomField = main.id ) WHERE (LOWER(main.Name) = 'constituency') AND (ObjectCustomFields_1.ObjectId = '0') AND (main.LookupType = 'RT::Queue-RT::Ticket') ORDER BY main.Disabled ASC LIMIT 1 That is a .3 seconds total for something that is essentially repeating the same two queries back to back that take a total of 0.85 ms. Is there something that I have misconfigured? Any ideas? I have attached the full set of queries. Regards, Ken
rt-ir-queries.gz
Description: GNU Zip compressed data
-------- We're hiring! http://bestpractical.com/jobs
