On Wed, Mar 18, 2009 at 03:01:30PM -0400, Miles Nordin wrote: > IMHO the best reaction to the KDE hysteria would be to make sure > SQLite and BerkeleyDB are fast as possible and effortlessly correct on > ZFS, and anything that's slow because of too much synchronous writing
I tried to do that for SQLite3. I ran into these problems: 1) The max page size for SQLite3 is 16KB. It can be made 32KB but I got some tests to core dump when I did that. It cannot go beyond that without massive changes to SQLite3. Or maybe the sizes in question were 32KB and 64KB -- either way, smaller than ZFS' preferred block size. 2) The SQLite3 tests depend on the page size being 1KB. So changing SQLite3 to select the underlying filesystem's preferred block size causes spurious test failures. 3) The default SQLite3 cache size becomes a very small 60 or so pages when maxing the page size. I suspect that will mean more pread(2) syscalls; whether that's a problem or not, I'm not sure. Therefore I held off putting back this change to SQLite3 in the OpenSolaris SFW consolidation. Nico -- _______________________________________________ zfs-discuss mailing list zfs-discuss@opensolaris.org http://mail.opensolaris.org/mailman/listinfo/zfs-discuss