Re: Subject: [PATCH] WC rep cache optimization for some file

2012-09-19 Thread Vasily Tunegov
t; >> Bert Huijben (Cell phone) >> From: Vasily Tunegov >> Sent: 19-9-2012 7:30 >> To: Philip Martin >> Cc: dev@subversion.apache.org >> Subject: Re: Subject: [PATCH] WC rep cache optimization for some file >> systems like NTFS on Windows >> Hi, P

Re: Subject: [PATCH] WC rep cache optimization for some file

2012-09-19 Thread Philip Martin
Philip Martin writes: > Mark Phippard writes: > >> Off-topic but related. What has happened to Philip's patch to enable >> exclusive locking for SQLite which "solves" the performance issue with NFS? >> I thought we were going to try to enable that via some runtime option or >> perhaps when we

Re: Subject: [PATCH] WC rep cache optimization for some file

2012-09-19 Thread Philip Martin
Mark Phippard writes: > Off-topic but related. What has happened to Philip's patch to enable > exclusive locking for SQLite which "solves" the performance issue with NFS? > I thought we were going to try to enable that via some runtime option or > perhaps when we detect the working copy is on n

Re: Subject: [PATCH] WC rep cache optimization for some file

2012-09-19 Thread Mark Phippard
On Wed, Sep 19, 2012 at 2:18 PM, Vasily Tunegov wrote: > I understand what WAL mode is not suitable for svn. But my patch uses > PERSIST mode which give very good results, e.g. for NTFS on Windows as I > shown in tests. > > One problem, as says Philip Martin, is reduced performance on NFS disks.

Re: Subject: [PATCH] WC rep cache optimization for some file

2012-09-19 Thread Vasily Tunegov
ng: 7bit > > For your own install you can enable the WAL on the file and other users > of the db will use it. I don't think we can enable it as default (like > you said) > > Bert Huijben (Cell phone) > From: Vasily Tunegov > Sent: 19-9-2012 7:30 > To: Philip Martin >

RE: Subject: [PATCH] WC rep cache optimization for some file

2012-09-19 Thread Bert Huijben
and other users of the db will use it. I don't think we can enable it as default (like you said) Bert Huijben (Cell phone) From: Vasily Tunegov Sent: 19-9-2012 7:30 To: Philip Martin Cc: dev@subversion.apache.org Subject: Re: Subject: [PATCH] WC rep cache optimization for some file systems like

Re: Subject: [PATCH] WC rep cache optimization for some file systems like NTFS on Windows

2012-09-19 Thread Vasily Tunegov
Hi, Philip I'm using SQLite 3.7.14. I tried to test checkout for our project code base, hosted on svn 1.7.6 server (93 984 Files, 3 204 Folders, 1.97GB). There are results: svn co snv://server/project/branches/branche src -q Standard disk: svn.r1387070 - 256.8 sec svn.patch - 152.2 sec My resea

Re: Subject: [PATCH] WC rep cache optimization for some file systems like NTFS on Windows

2012-09-19 Thread Philip Martin
Vasily Tunegov writes: > Please review my patch (see attached file patch.txt). It improve svn client > performance on file systems like NTFS on Windows. Maybe on some other file > systems, e.g. NFS, but I didn't test it. This patch switch rep cache db > journal mode from DELETE (by default) to PE