On Thu, May 7, 2009 at 9:57 PM, Jeff Palmer <je...@burstek.com> wrote: > Hello, > > > > I’m trying to use the rt command line to get a list of all tickets that were > modified yesterday. I currently have: > > > > rt ls -t ticket "Queue = 'Support' AND Status != 'rejected' AND LastUpdated > = '2009-05-06" > > > > It seems simple enough, but apparently the query is larger than I had > anticipated, because the web server times out before returning any results. > > I’m looking for ideas/optimizations, to make this faster and more reliable.
How many tickets do you have in support queue? For mysql ideal index would be (Queue, LastUpdated), however I don't think it's the problem, expecially if you have less than 100k tickets in the queue. Slow logs may help you identify real bottleneck. > As an aside, I know I can add the –f switch to pull things like id, and > subject. Is there a way to pull info out of a customfield also? An > example: > > rt ls -t ticket "Queue = 'Support' AND Status != 'rejected' AND LastUpdated > = '$EXPIRE'" -f id,subject,customfield I don't remember exact syntax, but it's probably CustomField.{Name} or something like that. Hope somebody come up with exact version :) > > Any help or advice would be greatly appreciated. > -- Best regards, Ruslan. _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com