Re: Worried about single-db performance

2010-09-07 Thread Branko Čibej
> Cc: 'Justin Erenkrantz'; 'Greg Stein'; 'Johan Corveleyn'; 'Subversion >>> Development' >>> Subject: Re: Worried about single-db performance >> >> >>> I didn't realise this, you are of course right that that woul

Re: Worried about single-db performance

2010-09-07 Thread Matthew Bentham
On 07/09/2010 13:02, Bert Huijben wrote: -Original Message- From: Matthew Bentham [mailto:mj...@artvps.com] Sent: dinsdag 7 september 2010 13:48 To: Bert Huijben Cc: 'Justin Erenkrantz'; 'Greg Stein'; 'Johan Corveleyn'; 'Subversion Development&#x

RE: Worried about single-db performance

2010-09-07 Thread Bert Huijben
> -Original Message- > From: Matthew Bentham [mailto:mj...@artvps.com] > Sent: dinsdag 7 september 2010 13:48 > To: Bert Huijben > Cc: 'Justin Erenkrantz'; 'Greg Stein'; 'Johan Corveleyn'; 'Subversion > Development' > Subject:

Re: Worried about single-db performance

2010-09-07 Thread Matthew Bentham
On 06/09/2010 15:18, Bert Huijben wrote: -Original Message- From: Matthew Bentham [mailto:mj...@artvps.com] Sent: maandag 6 september 2010 15:07 To: Justin Erenkrantz Cc: Bert Huijben; Greg Stein; Johan Corveleyn; Subversion Development Subject: Re: Worried about single-db performance

RE: Worried about single-db performance

2010-09-06 Thread Bert Huijben
> -Original Message- > From: Matthew Bentham [mailto:mj...@artvps.com] > Sent: maandag 6 september 2010 15:07 > To: Justin Erenkrantz > Cc: Bert Huijben; Greg Stein; Johan Corveleyn; Subversion Development > Subject: Re: Worried about single-db performance >

Re: Worried about single-db performance

2010-09-06 Thread Matthew Bentham
On 04/09/2010 17:33, Justin Erenkrantz wrote: Aha. Adding exclusive locking into our pragma [http://www.sqlite.org/pragma.html] calls in "svn_sqlite__open": "PRAGMA locking_mode=exclusive;" brings the time for "svn st" down from 0.680 to 0.310 seconds. And, yes, the I/O percentages drop drama

Re: Worried about single-db performance

2010-09-04 Thread Justin Erenkrantz
On Sat, Sep 4, 2010 at 2:23 AM, Bert Huijben wrote: > SQLite also does a stat call per statement, unless there is already a shared > lock open, just to check if there is no other process that opened a > transaction. > (On Windows this specific stat to check for other processes operating on the > s

Re: Worried about single-db performance

2010-09-04 Thread Branko Čibej
leyn; Subversion Development >> Subject: Re: Worried about single-db performance >> >> On Fri, Sep 3, 2010 at 8:39 AM, Greg Stein wrote: >>> It "should" already be faster. Obviously, that's not the case. >> I just spent a little bit time with Shar

RE: Worried about single-db performance

2010-09-04 Thread Bert Huijben
> -Original Message- > From: justin.erenkra...@gmail.com [mailto:justin.erenkra...@gmail.com] > On Behalf Of Justin Erenkrantz > Sent: zaterdag 4 september 2010 8:33 > To: Greg Stein > Cc: Johan Corveleyn; Subversion Development > Subject: Re: Worried about single-d

Re: Worried about single-db performance

2010-09-03 Thread Justin Erenkrantz
On Fri, Sep 3, 2010 at 8:39 AM, Greg Stein wrote: > It "should" already be faster. Obviously, that's not the case. I just spent a little bit time with Shark and gdb. A cold run of 'svn st' against Subversion trunk checkouts for 1.6 yields 0.402 seconds and 1.7 is 0.919 seconds. Hot runs for 1.6

Re: Worried about single-db performance

2010-09-03 Thread Greg Stein
On Fri, Sep 3, 2010 at 06:09, Johan Corveleyn 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 loc