spgetusersecurityrights

This forum is now locked, since Gold Support is no longer offered.

Moderator: SourceGear

Locked
kasti
Posts: 108
Joined: Tue Apr 20, 2004 4:21 am
Location: Austria

spgetusersecurityrights

Post by kasti » Wed May 09, 2007 8:02 am

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
Posts: 8550
Joined: Wed Jun 21, 2006 8:24 pm
Location: SourceGear
Contact:

Post by Beth » Wed May 09, 2007 2:31 pm

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.

Locked