Page 1 of 1

ServerOperations.Login() slow

Posted: Wed Jul 29, 2009 12:19 pm
by smartbear
We have several customers where our call to ServerOperations.Login() more than a minute to complete. Is there any way to improve on this?


Re: ServerOperations.Login() slow

Posted: Thu Jul 30, 2009 10:04 am
by jeremy_sg
Hey Eric,

I see two significant gaps The first is 46 seconds to load the CacheMember_Repository file. How big is that file?

There's also a 15s gap where it's cloning the full repository.

I think that the slowdown is a symptom of a really big repository. Does that match what your customer is saying about their Vault repository?

Re: ServerOperations.Login() slow

Posted: Tue Jan 12, 2010 11:55 am
by smartbear
The slow performance is continuing to be a problem for a number of our customers. Several are resigned to it, however, a couple customers are continuing to have problems with it, as making the connection takes several minutes. One of these customers reports their CacheMember_Repository file is 17MB. Is the problem with the performance of reading/writing this file? Is there anything you can do for them?

Re: ServerOperations.Login() slow

Posted: Tue Jan 12, 2010 1:08 pm
by jeremy_sg
In my experience, most customers who are reporting a long time to load the repository are benefited by reducing the number of nodes (folders and files) in their repository.

The best way to do that is to load up the NodeCounter power toy (from and look at the distribution of nodes in the tree. Figure out which nodes are no longer necessary, and delete them. It is not necessary to obliterate them to see a speed increase. Just delete them. If you ever need those folders again, you can undelete them.

For example, you can delete old branches that have been merged into trunk, as well as any old releases that we would no longer change, even if there was a bug.

Re: ServerOperations.Login() slow

Posted: Wed Jun 17, 2015 10:27 am
by RickS
Has this problem been solved with newer versions of SourceGear, or is the login performance slow on these many node repositories. Our standard login takes about 20-40 seconds, and we do it often... major user complaint.

Re: ServerOperations.Login() slow

Posted: Wed Jun 17, 2015 3:31 pm
by Beth
One of the things we found that speed up logins is turning off the option "Request Database Delta on Repository Cache Miss." This is in the Vault - Tools - Options - Concurrent Development Style

Other things that help are:

-- Work in VSS mode instead of CVS mode (causes extra scanning)
-- Don't turn on Ghosted files and folders (causes extra scanning)
-- Change the auto-update statistics setting per this KB article: ... 13&t=22358
-- SQL Maintenance:

There are more things one can look at, but these are the main ones that affect an initial login.