Re: [Monotone-devel] ideas to speed up monotone SQLite database access

[Daniel Carosone]

On Sun, Feb 05, 2006 at 02:39:34PM -0800, Joe Wilson wrote:
> (1) Use a larger default SQLite page size and/or cache size:

As well as the other reasons, another advantage of this is that it
reduces the IO per-transfer overhead from everything between the
syscall layer and the disk, and probably reduces the fragmentation and
seek contention for later reads.

This is a very good tip.  I'm not sure of the detailed impact on
sqlite, but I do the equivalent thing with postgresql on a regular
basis, and it's certainly worth pursuing.

--
Dan.

pgpVpxl_aFQ6t.pgp
Description: PGP signature