Re: [rt-users] Speed difference between superuser and others

2007-09-13 Thread Emmanuel Lacour
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 sec

Re: [rt-users] Speed difference between superuser and others

2007-08-24 Thread Emmanuel Lacour
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 loggi

Re: [rt-users] Speed difference between superuser and others

2007-08-24 Thread Kenneth Marshall
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/

Re: [rt-users] Speed difference between superuser and others

2007-08-24 Thread Emmanuel Lacour
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 vers

Re: [rt-users] Speed difference between superuser and others

2007-08-06 Thread Emmanuel Lacour
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 Queue

Re: [rt-users] Speed difference between superuser and others

2007-08-06 Thread Emmanuel Lacour
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 packag

Re: [rt-users] Speed difference between superuser and others

2007-07-20 Thread Jesse Vincent
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 gl

[rt-users] Speed difference between superuser and others

2007-07-20 Thread Emmanuel Lacour
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). The curious thing is that 90% of the time is wit