[rt-users] QuickSearch Too Slow - rt-3.6.0

[Umasankar Pandurangan]

Thanks for sharing your experience. It is quite insightful.

Will talk to the DBA about it.

Regards

Umasankar

________________________________
From: Joop <JoopvandeWege at mococo.nl>
To: Umasankar Pandurangan
Cc: 'rt-users at lists.bestpractical.com' <rt-users at lists.bestpractical.com>
Sent: Thu Nov 26 13:33:39 2009
Subject: Re: [rt-users] QuickSearch Too Slow - rt-3.6.0

Umasankar Pandurangan wrote:


Just wanted to check if there are any ways to optimize it that I am not aware of.

Indeed, we are planning to migrate it to a dual quad core, 4GB RAM server soon. I will also upgrade RT to the most recent version then.

On Tue 24.Nov'09 at 13:01:39 +0530, Umasankar Pandurangan wrote:


Hi,



I am using RT v3.6.0 on RHEL AS 3 with Oracle 9i as the back-end database on a Pentium server with 1GB of RAM. This RT instance is hosting two business
applications and there are close to 1200 queues on it.


Depending on how 'soon' is you might have your DBA have a look at the queries logged in the SGA to see if there are any that can be optimised by using an additional index. I'm on Oracle10g and came from 9i and know from experience that the optimiser in those versions got a good overhaul which helped RT quite a bit. Keep in mind though that QuickSearch is doing lots and lots of small queries so don't be surprised that your 10x faster machine only displays this widget 2x faster.

Regards,

Joop

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20091126/764394cc/attachment.htm>