Mailing List Archive: Request Tracker: Users

QuickSearch Too Slow - rt-3.6.0

Index | Next | Previous | View Threaded

Umashankar.Pandurangan at ip-soft

Nov 23, 2009, 11:31 PM

Post #1 of 6 (720 views)
Permalink

QuickSearch Too Slow - rt-3.6.0

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.

I am facing an issue with the "QuickSearch" widget on the RT web interface. It was too slow to load causing user login delays and sometimes it doesn't load at all. So I removed it from the "RT at a glance" page and made it available under a custom section I created on the left side menu. This addressed the login slowness issue much to the delight of most of the end users. However, some users who tend to use "QuickSearch" actively for getting an overview of ticket statistics on queues relevant to them complain that "QuickSearch is too slow" ;-)

I am looking for some ways to quicken up (and to justify the nomenclature to the end users :) ) this widget. Any ideas/suggestions would be appreciated.

Thanks.

PS: I did a search in wiki and lists but didn't find a case matching the problem I am facing. That's why I am writing to this list.

Regards,

Umasankar P

elacour at easter-eggs

Nov 23, 2009, 11:52 PM

Post #2 of 6 (689 views)
Permalink

Re: QuickSearch Too Slow - rt-3.6.0 [In reply to]

On Tue, Nov 24, 2009 at 01:01:39PM +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.
>
> I am facing an issue with the "QuickSearch" widget on the RT web
> interface. It was too slow to load causing user login delays and
> sometimes it doesn't load at all. So I removed it from the "RT at a
> glance" page and made it available under a custom section I created on
> the left side menu. This addressed the login slowness issue much to
> the delight of most of the end users. However, some users who tend to
> use "QuickSearch" actively for getting an overview of ticket
> statistics on queues relevant to them complain that "QuickSearch is
> too slow" ;-)
>
> I am looking for some ways to quicken up (and to justify the
> nomenclature to the end users :) ) this widget. Any ideas/suggestions
> would be appreciated.
>
> Thanks.
>
> PS: I did a search in wiki and lists but didn't find a case matching
> the problem I am facing. That's why I am writing to this list.
>

Look here:

http://www.gossamer-threads.com/lists/rt/users/75763?search_string=quicksearch%20slow;#75763

_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales [at] bestpractical

Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

jesse at bestpractical

Nov 25, 2009, 9:12 AM

Post #3 of 6 (680 views)
Permalink

Re: QuickSearch Too Slow - rt-3.6.0 [In reply to]

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.

RT 3.6.0 is over 3 years old. We've made many, many performance
improvements in the sixteen releases since then. Coming up to a recent RT
is the right first step. Additionally, if you folks have 1200 queues,
I suspect you'll get a LOT of utility out of upgrading to a more recent
server with more RAM than a $200 netbook.

_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales [at] bestpractical

Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Umashankar.Pandurangan at ip-soft

Nov 25, 2009, 7:30 PM

Post #4 of 6 (663 views)
Permalink

Re: QuickSearch Too Slow - rt-3.6.0 [In reply to]

Thanks, Jesse.

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.

----- Original Message -----
From: Jesse Vincent <jesse [at] bestpractical>
To: Umasankar Pandurangan
Cc: rt-users [at] lists <rt-users [at] lists>
Sent: Wed Nov 25 22:42:06 2009
Subject: Re: [rt-users] QuickSearch Too Slow - rt-3.6.0

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.

RT 3.6.0 is over 3 years old. We've made many, many performance
improvements in the sixteen releases since then. Coming up to a recent RT
is the right first step. Additionally, if you folks have 1200 queues,
I suspect you'll get a LOT of utility out of upgrading to a more recent
server with more RAM than a $200 netbook.

_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales [at] bestpractical

Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

JoopvandeWege at mococo

Nov 26, 2009, 12:03 AM

Post #5 of 6 (672 views)
Permalink

Re: QuickSearch Too Slow - rt-3.6.0 [In reply to]

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

Umashankar.Pandurangan at ip-soft

Nov 26, 2009, 12:19 AM

Post #6 of 6 (665 views)
Permalink

Re: QuickSearch Too Slow - rt-3.6.0 [In reply to]

Thanks for sharing your experience. It is quite insightful.

Will talk to the DBA about it.

Regards

Umasankar

________________________________
From: Joop <JoopvandeWege [at] mococo>
To: Umasankar Pandurangan
Cc: 'rt-users [at] lists' <rt-users [at] lists>
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

Index | Next | Previous | View Threaded

Interested in having your list archived? Contact Gossamer Threads