Config setting

RT Users
1

I am experiencing rather poor performance when I try to open a ticket. We are also seeing search results paint the screen very slowly in chunks.

My sys admins do not see anything in the system or db indicating why this would be. We have observed a large number for our transactions (6,403,137) and groups (1,830,636)

I noticed that a line in my config, which is not in my test system, that I cannot understand what it may want me to do.

Any suggestions very welcomed.

Thank You

Joe

It is
QueueCacheNeedsUpdate ‘1399672643’

Here are the items before and after.

SavedSearch {
‘Order’ => ‘DESC|DESC|ASC|ASC’,
‘Query’ => ‘Owner = 'CurrentUser' AND ( Status = 'resolved' )’,
‘SearchType’ => ‘Ticket’,
‘OrderBy’ => ‘LastUpdated|||’,
‘RowsPerPage’ => ‘10’,
‘Format’ => ‘'id/TITLE:#',
'Requestors',
'Subject/TITLE:Subject',
'LastUpdated'’
}
QueueCacheNeedsUpdate ‘1399672643’
SavedSearch {
‘Order’ => ‘ASC|ASC|ASC|ASC’,
‘Query’ => ‘Queue = 'SPAM' AND Created = 'Today'’,
‘SearchType’ => ‘Ticket’,
‘OrderBy’ => ‘CustomField.{SPAM-Origin}|Created|Requestor.EmailAddress|’,
‘Format’ => ‘'id/TITLE:#',
'Requestors',
'Subject/TITLE:Subject',
'ExtendedStatus',
'CreatedRelative',
'LastUpdatedRelative',
'CustomField.{SPAM-Origin}'’,
‘RowsPerPage’ => ‘100’
}

Joe Kirby , Assistant Vice President, Business Systems
Division of Information Technology (DoIT)
Support Response - http://www.umbc.edu/doit
Administration 627
Office - 410-455-3020
Email - kirby@umbc.edu

2

I am experiencing rather poor performance when I try to open a ticket. We are also seeing
search results paint the screen very slowly in chunks.
My sys admins do not see anything in the system or db indicating why this would be. We have
observed a large number for our transactions (6,403,137) and groups (1,830,636)
I noticed that a line in my config, which is not in my test system, that I cannot understand
what it may want me to do.
Any suggestions very welcomed.
Thank You
Joe
It is

QueueCacheNeedsUpdate                               '1399672643'

This is not part of your config, if you read the name of the box it is
in on the System Configuration page, it is a Global Attribute. It
tells RT when to flush the cache of Queues that a user sees (because
something has changed).

I find it doubtful that this is relevant to your performance problems.

Your admins can turn on StatementLog by setting it to 1 and looking
in the web UI to get a sense of what queries are running on particular
pages. They can also enable MasonX::Profiler as documented in
RT_Config.pm to see what parts of a page are specifically slow.

Both of these should be done on a development server.

-kevin