<HTML><BODY style="word-wrap: break-word; -khtml-nbsp-mode: space; -khtml-line-break: after-white-space; "><BR><DIV><DIV>On Apr 6, 2007, at 10:14 AM, Philip Kime wrote:</DIV><BR class="Apple-interchange-newline"><BLOCKQUOTE type="cite"> <DIV dir="ltr" align="left"><SPAN class="984161001-06042007"><FONT face="Arial" color="#0000ff" size="2">Hmm - not that I know of - we don't have that many users, even if they could all own tickets, it would be about 1300 users. Is that large enough to be a problem? Normally the Owner list is less than 100 users so I could check if someone did something. It seems back to normal now though ...</FONT></SPAN></DIV></BLOCKQUOTE><DIV><BR class="khtml-block-placeholder"></DIV><DIV>That was 288 users for the list, so maybe.</DIV><DIV><BR class="khtml-block-placeholder"></DIV><BLOCKQUOTE type="cite"><DIV dir="ltr" align="left"> </DIV> <DIV dir="ltr" align="left"><SPAN class="984161001-06042007"><FONT face="Arial" color="#0000ff" size="2">I noticed that the DB query was in the state "Copying to tmp table" for most of the time the query took.</FONT></SPAN></DIV></BLOCKQUOTE><DIV><BR class="khtml-block-placeholder"></DIV>That might indicate that your db wants a bit of tuning.</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>-j<BR><BR><BLOCKQUOTE type="cite"> <DIV dir="ltr" align="left"><SPAN class="984161001-06042007"><FONT face="Arial" color="#0000ff" size="2">PK</FONT></SPAN></DIV><BR></BLOCKQUOTE></DIV><BR></BODY></HTML>