Home My Page Projects FusionForge
Summary Activity Forums Tracker Lists News SCM Files Mediawiki Hudson/Jenkins

[#661] Enabling plugin very slow for projects with a site admin

Date:
2014-04-23 08:17
Priority:
3
State:
Closed
Submitted by:
Sylvain Beucler (beuc-inria)
Assigned to:
Sylvain Beucler (beuc-inria)
Target Release:
5.3.1
Found in Version:
5.3
Severity:
none
Resolution:
Fixed
Summary:
Enabling plugin very slow for projects with a site admin

Detailed description
Switching from git to svn in our "siteadmin" seems to create zillions DELETE requests on nss_usergroups.

I see that:
Group->setPluginUse(scmsvn, 1) -> Group->normalizeAllRoles()

This calls something like:
sysGroupAddUser -> sysGroupCheckUser -> sysGroupRemoveUser
(checkuser seems to remove and re-add users in all cases)

Everything looks sensible on a local point of view, but in the big picture, I'm triggering around 10 000 SQL queries per siteadmin member (5000 projects to quit and rejoin in a row).

Optimization?
Message  ↓
Date: 2014-05-15 14:04
Sender: Sylvain Beucler

Some optimization done in a02c2423f58a65adb811a8d3156b17bd982880a9

Field Old Value Date By
assigned_tonone2014-05-15 14:23nerville
status_idOpen2014-05-15 14:04beuc-inria
close_dateNone2014-05-15 14:04beuc-inria
Target ReleaseNone2014-05-15 14:04beuc-inria
ResolutionNone2014-05-15 14:04beuc-inria