[svn.haxx.se] · SVN Dev · SVN Users · SVN Org · TSVN Dev · TSVN Users · Subclipse Dev · Subclipse Users · this month's index

Re: SQLite and callbacks

From: Hyrum K Wright <hyrum_at_hyrumwright.org>
Date: Tue, 8 Feb 2011 17:13:50 +0000

On Tue, Feb 8, 2011 at 4:15 PM, Stefan Sperling <stsp_at_elego.de> wrote:
> On Tue, Feb 08, 2011 at 04:34:52PM +0100, Bert Huijben wrote:
>> There is nobody actively working on status and there are no open
>> issues on status to block branching...
>
> There's the general wc-ng performance issue (but I don't think it has
> an issue number attached to it right now).

If performance of 'status' is a release blocker, we need to document
and treat it as such.

Also instead of nebulous handwaving about "performance is bad", it
would be nice to have actually datasets and actual numbers. We have a
VM at the ASF which could be used for hosting a set of benchmarking
data; we just need somebody to put together the data and write the
scripts which run the benchmarks.

[And yes, I realize that I bring up all these points without actually
volunteering to help with the situation. *sigh* ]

>> So if status is still a show-stopper we should focus on that instead
>> of trying to improve 'svn proplist -R', which is not a very common
>> operation in svn. (Merge works per node, so it doesn't benefit from
>> the performance enhancements :( )
>
> I started working on proplist because it's pretty simple and therefore
> a good way to get going. My end goal is not to improve proplist.
> I want to understand where wc-ng performance problems come from and
> how to fix them.
>
> I do intend to look at other subcommands once proplist has been dealt with.
>
>>
>> As things are today it looks like status will be released in its current form for 1.7.
>> I don't see a problem with the current status performance from my perspective; unless somebody decides to just disable in memory temptables without profiling to fix some other issues in a different place.
>
> Ah, so status performs well using per-node queries?
> I thought it was still worse compared to 1.6.x for some use cases.
> See http://svn.haxx.se/dev/archive-2010-09/0526.shtml
> I think we should try to get trunk to perform at least as well as 1.6.x
> for all uses cases before release.
>
>> I don't have a problem with choosing file backed temptables over
>> memory backed, but I do have an issue with doing it for theoretical
>> reasons which are only tested under very specific circumstances. And a
>> recursive proplist is not a very common and/or performance critical
>> subversion operation from my perspective.
>
> Of course proplist isn't very critical. But that's not the point.
>
> The point is that Subversion should be written in a way that prevents
> it from running out of memory when it operates on large working copies.
> What if users run into problems with large working copies with 1.7?
> Have we tested what happens with very large working copies?
>
> Code that blows up if the input data set is too large is not acceptable.
> Using file-backed temporary tables might be slower, but it's a safe default.

I've been pleading with folks I know who use large working copies to
do some testing, but I haven't gotten any feedback from them, partly
because following up with everybody is kind of a pain, and partly
because there aren't any packaged binaries for people to test. Would
it be worth it to have a beta-testers_at_subversion.apache.org list,
which we could use to communicate with the bleeding-edge folks in
release situations like this?

It shouldn't be difficult to create a large working copy ('svn co
^/subversion') and use that for testing, but getting more insight than
just our own dataset would be very nice.

-Hyrum
Received on 2011-02-08 18:14:33 CET

This is an archived mail posted to the Subversion Dev mailing list.

This site is subject to the Apache Privacy Policy and the Apache Public Forum Archive Policy.