Search found 4 matches

by mry
Mon Oct 19, 2009 12:58 am
Forum: Support (Vault)
Topic: improving performance of spQueryHistory
Replies: 13
Views: 2989

Re: improving performance of spQueryHistory

I already included the logs both with and without branch action selected in the previous post (the code block). I did omit other users, but the server load was comparable at the times for all the three tests. Also, as I already stated, the full log is almost 700mb, which is much larger than I can em...
by mry
Fri Oct 16, 2009 2:26 am
Forum: Support (Vault)
Topic: improving performance of spQueryHistory
Replies: 13
Views: 2989

Re: improving performance of spQueryHistory

Is there anything else we can supply to aid in looking into the issue? More of the logs? Other testcases?
by mry
Wed Oct 07, 2009 5:25 am
Forum: Support (Vault)
Topic: improving performance of spQueryHistory
Replies: 13
Views: 2989

Re: improving performance of spQueryHistory

Maintenance is done on the sql database every weekend. The project is fairly small - it's slightly over 1000 files in it, most files having a single revision. There are some labels, but no branches, so the history is very straightforward. It isn't a database performance issue per se - when it times ...
by mry
Tue Oct 06, 2009 6:58 am
Forum: Support (Vault)
Topic: improving performance of spQueryHistory
Replies: 13
Views: 2989

Re: improving performance of spQueryHistory

We've gotten the same problem where getting the history for a project has started to timeout. After investigating the problem, it appears there's something not quite right with how spqueryhistory is performed. We recently merged two repositories (exported from our small repository and imported into ...