[rt-users] How to improve performance ?

[Vivek Khera]

On Mar 3, 2005, at 8:29 AM, Andre Sachs wrote:

> We have indexed the tables but no appreciable speed up has been 
> witnessed.
>

after you "analyze" your tables, what does "explain" have to say about 
your above queries?

I posted here a while back some alternative indexes for RT 3.2 based on 
my experiences.  There are a few indexes that are totally unused which 
just add disk I/O during updates/inserts that are wasted.

Vivek Khera, Ph.D.
+1-301-869-4449 x806