On Fri, Aug 24, 2007 at 11:20:36AM +0200, Emmanuel Lacour wrote: > On Mon, Aug 06, 2007 at 04:59:48PM +0200, Emmanuel Lacour wrote: > > On Mon, Aug 06, 2007 at 12:29:03PM +0200, Emmanuel Lacour wrote: > > > > > > 1.49 is packaged at > > > http://dag.wieers.com/rpm/packages/perl-DBIx-SearchBuilder/ since > > > yesterday, so I will try it ;) > > > > > > > I tested this last version without any performance improvement :( > > > > Rt is 3.6.3, with a backport of QueueSummary from 3.6.4 > > > > I found that the 90% of the time of the first RT acces with a non > superuser user is for checking ACLs of queues. It does about 800 SQL > requests for RT at a Glance (I have 189 queues, displayed three times > on RT at a Glance default page). > > As the result, the first access take 5 minutes to display this page. > > A second access use the session RT cache and take only 20 seconds (which > remains slow :(). > > We are using an oracle database (9.2.0.7.0). This database is on a > dedicated server with Gigabit connexion to the RT server. > > We do not see any problem with databse performances, could this speed > problem be related to the fact that the database is on a diff??rent > server (the database server as a ping of about 2ms from the RT server). > > Thanks for any hints on solving this performance problem :( > > > -- > Emmanuel Lacour ------------------------------------ Easter-eggs > 44-46 rue de l'Ouest - 75014 Paris - France - M??tro Gait?? > Phone: +33 (0) 1 43 35 00 37 - Fax: +33 (0) 1 41 35 00 76 > mailto:[EMAIL PROTECTED] - http://www.easter-eggs.com
Emmanuel, That does seem a little bit excessive. 800 SQL queries in 5 minutes is about 1/3 second per query which seems slow to me. You may want to turn on query logging/timing and try to analyze them to find the bottleneck. We only have 80 queues, but the initial load takes about 2.5 seconds the first time and 2 seconds thereafter. Good luck with your performance tuning. Regards, Ken Marshall _______________________________________________ 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
