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

[Ruslan Zakirov]

On Wed, Dec 5, 2012 at 7:11 PM, ktm at rice.edu <ktm at rice.edu> wrote:
> 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.

1) File a bug, we should try to avoid running this queries for not RTIR tickets.
2) Send explain of the query
3) Optimize execution with an index or two, it shouldn't take that
long to load a CF

> Regards,
> Ken
>
> --------
> We're hiring! http://bestpractical.com/jobs


-- 
Best regards, Ruslan.