continuum-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Emmanuel Venisse <emmanuel.veni...@gmail.com>
Subject Re: Adding project groups takes longer and longer
Date Mon, 15 Jun 2009 18:58:07 GMT
It's very bad.

Do you use  an embedded derby DB or an external? I don't think it is good to
use an embedded DB for a "big" DB.

Emmanuel

On Mon, Jun 15, 2009 at 6:39 PM, Wendy Smoak <wsmoak@gmail.com> wrote:

> I've noticed Continuum getting slower and slower... we're trying to
> track down exactly why, but one theory relates to there being lots of
> user roles that have to be checked, which would mean there are lots of
> project groups.
>
> To try to reproduce that, I added 400 groups to a fresh Continuum
> 1.3.3 instance.  I notice that it takes longer and longer to add each
> group.  Here's a graph:
>
> http://people.apache.org/~wsmoak/continuum/continuum-1.3.3-add-400-groups.png<http://people.apache.org/%7Ewsmoak/continuum/continuum-1.3.3-add-400-groups.png>
>
> On trunk it's similar.  There in the audit log I can see there are 3
> seconds between adding the second and third groups, and 19 seconds
> between groups 399 and 400.  All in all it takes over an hour to add
> 400 groups to an instance.
>
> The test code is in the sandbox:
>
> http://svn.apache.org/repos/asf/continuum/sandbox/continuum-webapp-test-many-roles/
>
> Any ideas?  Are we missing an index on some field?
>
> --
> Wendy
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message