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

Re: PRAGMA page_size;

From: Daniel Shahaf <danielsh_at_elego.de>
Date: Thu, 16 Feb 2012 18:45:55 +0200

So, tldr: sqlite gets the default right usually.

Thanks for digging into this :)

Daniel
(FWIW: the bacground here is a 1.6 merge which was spending most of its
time reading an entries file)

Philip Martin wrote on Thu, Feb 16, 2012 at 11:01:33 +0000:
> Julian Foad <julianfoad_at_btopenworld.com> writes:
>
> > I (Julian Foad) wrote:
> >
> >> This thread seems to have a useful discussion:
> >> <https://bugzilla.mozilla.org/show_bug.cgi?id=416330#c3>, which
> >> seems to be saying that a larger default seemed to be helpful for
> >> Mozilla on Windows.
> >
> > Ah, I suppose the most interesting thing right now is to experiment on
> > an network-mounted WC, as that might be the scenario most likely to
> > show big changes where the default might be poor.
>
> I tried 4K and 8K when experimenting with locking_mode and didn't see
> any improvements. That's on my Linux-Linux NFS setup where both sides
> default to 1K.
>
> --
> uberSVN: Apache Subversion Made Easy
> http://www.uberSVN.com
Received on 2012-02-16 17:49:30 CET

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