[rt-users] TicketHistory slow on 4.2.0

[Alex Vandiver]

On Mon, 2013-10-28 at 09:54 -0400, Tod Detre wrote:
> Adding the index did indeed fix the issue. I've pasted the line from
> the SQL log below. It looks like the query is coming from
> RT::Transaction. I'm not that great at perl so I'm not sure, but I
> think it might be the method LoadCustomFieldByIdentifier. I do know
> that the URL that starts the query is /Helpers/TicketHistory.
> 
> [29826] [Mon Oct 28 13:33:12 2013] [debug]: SQL(2.188469s): SELECT
> count(main.id) FROM ObjectCustomFieldValues main  WHERE (main.Disabled
> = '0') AND (main.ObjectId = '307581') AND (main.ObjectType =
> 'RT::Transaction') ; (/opt/rt4/sbin/../lib/RT/Interface/Web.pm:1292)

To be useful, we'd unfortunately need to know the full stack trace.  The
full stack trace is shown in the UI in the Admin → Tools → SQL Queries
page if StatementLog is enabled.
 - Alex