[Default] On Tue, 21 Oct 2008 15:43:08 -0400, Bill Sommerfeld <[EMAIL PROTECTED]> wrote:
>On Mon, 2008-10-20 at 16:57 -0500, Nicolas Williams wrote: >> >> I've a report that the mismatch between SQLite3's default block size >> and ZFS' causes some performance problems for Thunderbird users. > > I was seeing a severe performance problem with sqlite3 databases > as used by evolution (not thunderbird). > > It appears that reformatting the evolution databases to a 32KB database > page size and setting zfs's record size to a matching 32KB has done > wonders for evolution performance to a ZFS home directory. Just a remark: Increasing the SQLite page_size while keeping the same [default_]cache_size will effectively increase the amount of memory allocated to the SQLite cache, because the SQLite cache_size is expressed in pages. IMHO, for a fair performance comparison, one should half the cache_size when the page_size is doubled. [snip] > > - Bill > -- ( Kees Nuyt ) c[_] _______________________________________________ zfs-discuss mailing list zfs-discuss@opensolaris.org http://mail.opensolaris.org/mailman/listinfo/zfs-discuss
