[rt-users] Slower ticket display with RT-IR installed

[ktm at rice.edu]

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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: rt-ir-queries.gz
Type: application/x-gzip
Size: 9750 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20121205/78c84f26/attachment.bin>