spgetusersecurityrights

[kasti]

Hi,

using Vault 3.5.2

This is another vault performance thread. First some stats:

Create New Folder: 15 seconds
Delete Empty Folder: 30 seconds


Tracing on the SQL Server shows that spgetusersecurityrights is executed for every connected user. This SP needs on average 360mSec to run. So if 30 users are online, its 30 * 360mSec.

The bad thing is that this SP runs for every logged in user before the create/delete command completes (and I guess also on other actions).

Now the question is, is this SP required to run so often? Should it take so long? I seems to me that with every logged in user, vault slows down considerable because of this.


Thanks,
Herbert.

[Beth]

When one has the folder security enabled on a repository, any time a user does a transaction, it will check the security rights. It's not really cumulative I believe, so you shouldn't end up with the kind of lag you are expecting.

I'm going to check this out a bit more and post back again.