Improving "Show Labels" Performance

kasti · Post by **kasti** » Thu Sep 07, 2006 3:57 am

Hi,

Using vault 3.5:

I have noticed that the "show label" command is extremely slow on projects which have many shares (it takes 2 minutes on some shared projects here) while the "show history" -> label actions only is almost instant. Since both queries (should i think) return the same result (except sort order and created at field), is it possible to improve the performance of "show label"?

Thanks,
Herbert.

Beth · Post by **Beth** » Thu Sep 07, 2006 10:29 am

Sorry, for the delay, still looking into this one. In the meantime, can you tell me more about your environment, such as Server OS, SQL version, are they on the same machine, .NET version?

Does this happen the same way for every client?

Beth · Post by **Beth** » Thu Sep 07, 2006 3:08 pm

Could you go ahead and put your server log into debug mode and reproduce the issue and then send the log to me? Details can be found here: http://support.sourcegear.com/viewtopic.php?p=6278 You can send it as a private messager here or in an email and just reference this post.

ismangil · Post by **ismangil** » Wed Sep 13, 2006 2:15 am

Somewhat related, on Vault 3.1.7, merging fails when the wizard was "retrieving origin history" due to (from server log): BeginLabelQuery returned: FailDBInsert

I think the beginlabelquery timed out. We do have quite a few labels due to our build process. Would it help if we delete old labels? Or would it make it worse because the "delete label" itself will generate more history?

Beth · Post by **Beth** » Wed Sep 13, 2006 10:00 am

Somewhat related, on Vault 3.1.7, merging fails when the wizard was "retrieving origin history" due to (from server log): BeginLabelQuery returned: FailDBInsert

You might want to check out this post, and try restarting IIS to see if it clears that up:
http://support.sourcegear.com/viewtopic.php?t=323

Would it help if we delete old labels? Or would it make it worse because the "delete label" itself will generate more history?

You probably would want to improve performance in other ways first before you consider deletions. I don't believe deleting labels will help much.
Things that should help are to make sure your database is in good shap: http://support.sourcegear.com/viewtopic.php?t=2924
and checking out our article on improving performance: http://support.sourcegear.com/viewtopic.php?t=4206.

M Wickardt · Post by **M Wickardt** » Thu Sep 14, 2006 7:32 am

In vaultagent http://support.sourcegear.com/viewtopic.php?t=6605, with the following command:

Code: Select all

history -begindate 1-9-2006 $/your/path -excludeactions checkin,pin

You can get the labels very quickly, all be it in a 'less chiq' format (xml).

ismangil · Post by **ismangil** » Fri Sep 15, 2006 2:35 am

Beth wrote: I don't believe deleting labels will help much.

Since we've pretty much done all the suggested steps as a matter of process (weekly DB tuning etc), I went and deleted the unnecessary labels anyway. About a thousand build labels were deleted, and now the merge process works as normal.

As a result we have now implemented a label aging policy: a small tool is run at every build, deleting all labels more than two weeks old and an exclusion list (release builds etc).

So here's a feature request:

For a given folder, we should be able to specify auto deletion of old labels and with an exclusion list.

Thanks for all your help!

Beth · Post by **Beth** » Fri Sep 15, 2006 8:45 am

For Kasti and other that may have a slow-down with labels. There is a bug logged for improving the performance with that, and I will add any additional votes to it.

To ensure you don't have other issues going on that may be affecting it, you will want to make sure your database is in good shape: http://support.sourcegear.com/viewtopic.php?t=2924
and check out our article on improving performance: http://support.sourcegear.com/viewtopic.php?t=4206.
Also watch your logs for any errors that may be generated.

Thanks for all the input.