<html><head><meta http-equiv="Content-Type" content="text/html charset=us-ascii"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;">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.<div><br></div><div>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)<br><div><br></div><div>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.</div><div><br></div><div>Any suggestions very welcomed.</div><div><br></div><div>Thank You</div><div><br></div><div>Joe</div><div><br></div><div><br></div><div>It is <table class="collection" border="0" cellpadding="5" cellspacing="0" width="100%" style="position: static; z-index: auto;"><tbody><tr class="evenline"><td>QueueCacheNeedsUpdate</td><td>'1399672643'</td></tr></tbody></table><div><br></div><div><br></div><div>Here are the items before and after.</div><div><br></div><div><table class="collection" border="0" cellpadding="5" cellspacing="0" width="100%"><tbody><tr class="oddline"><td>SavedSearch</td><td>{<br> 'Order' => 'DESC|DESC|ASC|ASC',<br> 'Query' => 'Owner = \'__CurrentUser__\' AND ( Status = \'resolved\' )',<br> 'SearchType' => 'Ticket',<br> 'OrderBy' => 'LastUpdated|||',<br> 'RowsPerPage' => '10',<br> 'Format' => '\'<a href="__WebPath__/Ticket/Display.html?id=__id__">__id__</a>/TITLE:#\',<br>\'__Requestors__\',<br>\'<a href="__WebPath__/Ticket/Display.html?id=__id__">__Subject__</a>/TITLE:Subject\',<br>\'__LastUpdated__\''<br> }<br></td>
</tr>
<tr class="evenline">
<td>QueueCacheNeedsUpdate</td><td>'1399672643'<br></td>
</tr>
<tr class="oddline">
<td>SavedSearch</td><td>{<br> 'Order' => 'ASC|ASC|ASC|ASC',<br> 'Query' => 'Queue = \'SPAM\' AND Created = \'Today\'',<br> 'SearchType' => 'Ticket',<br> 'OrderBy' => 'CustomField.{SPAM-Origin}|Created|Requestor.EmailAddress|',<br> 'Format' => '\'<a href="/Ticket/Display.html?id=__id__">__id__</a>/TITLE:#\',<br>\'__Requestors__\',<br>\'<a href="/Ticket/Display.html?id=__id__">__Subject__</a>/TITLE:Subject\',<br>\'__ExtendedStatus__\',<br>\'__CreatedRelative__\',<br>\'__LastUpdatedRelative__\',<br>\'__CustomField.{SPAM-Origin}__\'',<br> 'RowsPerPage' => '100'<br> }</td></tr></tbody></table><div><br></div></div><div><br></div><div><br></div><div apple-content-edited="true">
<span class="Apple-style-span" style="border-collapse: separate; border-spacing: 0px;"><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div>Joe Kirby , Assistant Vice President, Business Systems</div><div>Division of Information Technology (DoIT) </div><div>Support Response - <a href="http://www.umbc.edu/doit">http://www.umbc.edu/doit</a> </div><div>Administration 627</div><div>Office - 410-455-3020 </div><div>Email - <a href="mailto:kirby@umbc.edu">kirby@umbc.edu</a></div></div></span></span>
</div>
<br></div></div></body></html>