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 _______________________________________________ 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
