[rt-users] Expensive Queries

[Jeff Stark]

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: rt-users-bounces at lists.bestpractical.com
[mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Kenneth
Marshall
Sent: Tuesday, May 15, 2007 2:34 PM
To: Brian_Gupta at timeinc.com
Cc: rt-users at lists.bestpractical.com
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, Brian_Gupta at timeinc.com 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: 
> sales at bestpractical.com
> 
> 
> 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:
sales at bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com