[rt-users] Expensive Queries

[Kenneth Marshall]

Justin,

I never saw any problem plans posted, but some of the most needed
indexes reduced the need for a sequential scan of a table by replacing
it with an index lookup. Here are some candidates to check for in your
DB instance:

CREATE UNIQUE INDEX Queues1 ON Queues (lower(Name)) ;

CREATE INDEX GroupMembers1 ON GroupMembers (GroupID);

CREATE UNIQUE INDEX Users1 ON Users (lower(Name)) ;

CREATE INDEX Users2 ON Users (lower(EmailAddress));

CREATE INDEX Tickets4 ON Tickets (Status);

Again look for slow queries caused by sequential scans of a
table. I think that Oracle has something equivalent to the
functional indexes above to allow you to index the lowercased
values. Good luck in your performance problem seek-n-destroy.

Ken

On Tue, May 15, 2007 at 11:08:14AM -0700, Justin Brodley wrote:
> Has this been integrated with RT?
> 
> Justin Brodley
> 
> -----Original Message-----
> From: rt-users-bounces at lists.bestpractical.com
> [mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of
> Brian_Gupta at timeinc.com
> Sent: Tuesday, May 15, 2007 11:00 AM
> To: rt-users at lists.bestpractical.com
> Subject: Re: [rt-users] Expensive Queries
> 
> > Thanks Ken and Jesse.  We will continue to evaluate to see if we can
> > find some performance gains in other ways.
> > 
> > -Stark
> 
> Are the queries repeated? If so then memcached might be able to help you
> out.  http://en.wikipedia.org/wiki/Memcached
> 
> -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
>