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 <wsm...@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 >
