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

Re: Worried about single-db performance

From: Greg Stein <gstein_at_gmail.com>
Date: Fri, 3 Sep 2010 11:39:38 -0400

On Fri, Sep 3, 2010 at 06:09, Johan Corveleyn <jcorvel_at_gmail.com> wrote:
> Hi devs,
>
> From what I understand about the performance problems of WC-1 vs.
> WC-NG, and what I'm reading on this list, I expect(ed) a huge
> performance boost from WC-NG for certain client operations (especially
> on Windows, where the locking of WC-1 is quite problematic). Also, I
> knew I had to wait for single-db to see any real performance benifits.
> So after you guys switched on single-db, I eagerly gave trunk a
> spin... Now I'm a little worried, because I don't see any great speed
> increases (quite the contrary). Some details below.
>
> Maybe it's just too early to be looking at this (maybe it's a simple
> matter of optimizing the data model, adding indexes, optimizing some
> code paths, ...). So it's fine if you guys say: chill, just wait a
> couple more weeks. I just need to know whether I should be worried or
> not :-).

It "should" already be faster. Obviously, that's not the case.

My expectation is that it would be faster, and then we'd do some perf
improvements to make it even faster. Sounds like we definitely have to
do some of those other improvements.

We have a schema change to make, and once that is done, then we can
start looking at the performance. There could be lots of SQL queries
that need to be optimized. I also *know* that we issue way too many
queries. There should be ways to avoid a lot of those queries.

I'd like to avoid any caching, and rely on SQLite to maintain
in-memory caches. My gut says we just need to reduce the number of
queries.

Cheers,
-g
Received on 2010-09-03 17:40:18 CEST

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