Re: [rt-users] Config setting

[Kevin Falcone]

On Fri, May 09, 2014 at 06:06:43PM -0400, Joe Kirby wrote:
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


pgpX6Cwot2WlZ.pgp
Description: PGP signature
-- 
RT Training - Dallas May 20-21
http://bestpractical.com/training

[rt-users] Config setting

[Joe Kirby]

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' = '\'a 
href=__WebPath__/Ticket/Display.html?id=__idid__/a/TITLE:#\',
\'__Requestors__\',
\'a 
href=__WebPath__/Ticket/Display.html?id=__idSubject__/a/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' = '\'a 
href=/Ticket/Display.html?id=__idid__/a/TITLE:#\',
\'__Requestors__\',
\'a href=/Ticket/Display.html?id=__idSubject__/a/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 - ki...@umbc.edu

-- 
RT Training - Dallas May 20-21
http://bestpractical.com/training