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
PCTFREE 10
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
