[rt-users] RT performance issue

[Joop]

Varun Vyas wrote:
> Hello All.
>
> Well we have deployed RT 3.6.3 on oracle 9i database as an backend
> in a medium sized firm and we have lots of tickets processed everyday
> more than 100. My problem is that the application is very irresponsive
> and very slow. We have already 8 gigs of RAM on our webserver with
> Apache 2.0 and fastCGI implemented. Also we have performed indexing on
> our oracle database with fastcgi implemented. But nothing seems to be going in our way. So please anyone can suggest wat will be the problem. I m looking for concerete answer to my problem. On which side i need to tune on application side or on database side and if on both side what step i need to take to make my application lightning fast.With acceptable level of performance.
>   
You might have 8G or RAM but how much is being allocated to Oracle ?
Please specify in either terms of SGA/PGA and automatic memory 
allocation or as dedicated SGA/blockbuffer pool allocations

Further is it Oracle that is slow or is it Apache that is being slow?

Which things are slow? (Searching on ticket CONTENT is without proper 
context indexing reeeaaaal slow.), not to mention that standard 
SearchBuilder pre and post pends % to queries, effectively disabling the 
use of indices :-((

Regards,

Joop

(PS:
Contact me off list if you need specific help
)