Thanks for sharing your experience. It is quite insightful. Will talk to the DBA about it.
Regards Umasankar ________________________________ From: Joop <[email protected]> To: Umasankar Pandurangan Cc: '[email protected]' <[email protected]> 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
_______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [email protected] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
