Re: [zfs-discuss] Setting per-file record size / querying fs/file record size?

2008-12-01 Thread Roch
Bill Sommerfeld writes: On Wed, 2008-10-22 at 10:30 +0100, Darren J Moffat wrote: I'm assuming this is local filesystem rather than ZFS backed NFS (which is what I have). Correct, on a laptop. What has setting the 32KB recordsize done for the rest of your home dir, or did

Re: [zfs-discuss] Setting per-file record size / querying fs/file record size?

2008-10-22 Thread Darren J Moffat
Bill Sommerfeld 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

Re: [zfs-discuss] Setting per-file record size / querying fs/file record size?

2008-10-22 Thread Bill Sommerfeld
On Wed, 2008-10-22 at 10:30 +0100, Darren J Moffat wrote: I'm assuming this is local filesystem rather than ZFS backed NFS (which is what I have). Correct, on a laptop. What has setting the 32KB recordsize done for the rest of your home dir, or did you give the evolution directory its own

Re: [zfs-discuss] Setting per-file record size / querying fs/file record size?

2008-10-22 Thread Kees Nuyt
[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

Re: [zfs-discuss] Setting per-file record size / querying fs/file record size?

2008-10-22 Thread Nicolas Williams
On Wed, Oct 22, 2008 at 11:05:09PM +0200, Kees Nuyt wrote: [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'

Re: [zfs-discuss] Setting per-file record size / querying fs/file record size?

2008-10-22 Thread Nicolas Williams
On Wed, Oct 22, 2008 at 04:31:43PM -0500, Nicolas Williams wrote: On Wed, Oct 22, 2008 at 11:05:09PM +0200, Kees Nuyt wrote: 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

Re: [zfs-discuss] Setting per-file record size / querying fs/file record size?

2008-10-21 Thread Nicolas Williams
On Mon, Oct 20, 2008 at 04:57:22PM -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. It'd be great if there was an API by which SQLite3 could set its block size to match the

Re: [zfs-discuss] Setting per-file record size / querying fs/file record size?

2008-10-21 Thread Bill Sommerfeld
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

Re: [zfs-discuss] Setting per-file record size / querying fs/file record size?

2008-10-21 Thread Nicolas Williams
On Tue, Oct 21, 2008 at 03:43:08PM -0400, Bill Sommerfeld 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

Re: [zfs-discuss] Setting per-file record size / querying fs/file record size?

2008-10-21 Thread Robert Milkowski
Hello Nicolas, Monday, October 20, 2008, 10:57:22 PM, you wrote: NW I've a report that the mismatch between SQLite3's default block size and NW ZFS' causes some performance problems for Thunderbird users. NW It'd be great if there was an API by which SQLite3 could set its block NW size to match

[zfs-discuss] Setting per-file record size / querying fs/file record size?

2008-10-20 Thread Nicolas Williams
I've a report that the mismatch between SQLite3's default block size and ZFS' causes some performance problems for Thunderbird users. It'd be great if there was an API by which SQLite3 could set its block size to match the hosting filesystem or where it could set the DB file's record size to