Re: [rt-users] Speed difference between superuser and others
On Fri, Aug 24, 2007 at 03:34:08PM +0200, Emmanuel Lacour wrote: On Fri, Aug 24, 2007 at 07:51:35AM -0500, Kenneth Marshall wrote: On Fri, Aug 24, 2007 at 11:20:36AM +0200, Emmanuel Lacour wrote: 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. Thanks for your answer, I think also that it is a database issue, I'm going to look at it in depth ;) Fixed, on this Oracle 9.2.0.7.0, we had to create the following index (don't know why the DisGrouMem index is not used :(): CREATE INDEX GemDisMem ON CachedGroupMembers (Disabled, MemberId) LOGGING TABLESPACE USERS PCTFREE10 INITRANS 2 MAXTRANS 255 STORAGE( INITIAL 64K MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 BUFFER_POOL DEFAULT ) NOPARALLEL; with this, it's working fine :) Note: I tested on a 10g database, the speed is ok without this index... -- Emmanuel Lacour ___ 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
Re: [rt-users] Speed difference between superuser and others
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
Re: [rt-users] Speed difference between superuser and others
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
Re: [rt-users] Speed difference between superuser and others
On Fri, Aug 24, 2007 at 07:51:35AM -0500, Kenneth Marshall wrote: On Fri, Aug 24, 2007 at 11:20:36AM +0200, Emmanuel Lacour wrote: 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. Thanks for your answer, I think also that it is a database issue, I'm going to look at it in depth ;) -- Emmanuel Lacour ___ 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
Re: [rt-users] Speed difference between superuser and others
On Fri, Jul 20, 2007 at 11:54:45AM -0400, Jesse Vincent wrote: What RT and what SearchBuilder? The loop you show suggest that it's an ancient version of DBIx::SearchBuilder with a big caching problem. Comming back from vacations ... ;) I'm using version 1.43 (the one I found packaged for RH :(), I didn't clearly identify your caching problem in the change file from this release, is 1.43 affected ? 1.49 is packaged at http://dag.wieers.com/rpm/packages/perl-DBIx-SearchBuilder/ since yesterday, so I will try it ;) Thanks for your help :) -- 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
Re: [rt-users] Speed difference between superuser and others
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 -- 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
Re: [rt-users] Speed difference between superuser and others
On Jul 20, 2007, at 4:00 AM, Emmanuel Lacour wrote: Hi, I have a big performance problem here: When I connect to my RT system with a superuser account, it's fine. When I connect with a normal privileged user, without groups or any rights, It's really slow (more than 3 minutes for Rt at a glance). What RT and what SearchBuilder? The loop you show suggest that it's an ancient version of DBIx::SearchBuilder with a big caching problem. Best, Jesse PGP.sig Description: This is a digitally signed message part ___ 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