They are just saved searches we are displaying on the home page....I am not sure exactly where that specific query that I posted was created, but where we are seeing the biggest performance hit is on RT at a Glance.
Thanks for the feedback on the indexes, we shall give them a try. - Stark -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kenneth Marshall Sent: Tuesday, May 15, 2007 2:34 PM To: [EMAIL PROTECTED] Cc: [email protected] Subject: Re: [rt-users] Expensive Queries We are running RT 3.4.5 on PostgreSQL with 1200 open tickets and 110k tickets processed and growing. We have no performance problem to speak of. How are you generating the slow query? Ken On Tue, May 15, 2007 at 02:18:15PM -0400, [EMAIL PROTECTED] wrote: > > Has this been integrated with RT? > > > > Justin Brodley > > I suspect that most people are running RT with MySQL, so it is quite > unlikely that enough people have run into performance issues that need > to be resolved by memcached. That said, I'd imagine it would be fairly > trivial to get up and running. > > I'd be interested in hearing what Jesse has to say on this topic. > > -Brian > > Brian Gupta > Time Inc > Information Technology Dept > 212-522-1401 > _______________________________________________ > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users > > Community help: http://wiki.bestpractical.com Commercial support: > [EMAIL PROTECTED] > > > Discover RT's hidden secrets with RT Essentials from O'Reilly Media. > Buy a copy at http://rtbook.bestpractical.com > _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
