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 the hosting filesystem or where it could set the DB file's
NW> record size to match the SQLite3/app default block size (1KB).

NW> Is there such an API?  If not, is there an RFE I could add a call record
NW> to?

Maybe it would be also useful to provide an extra API so application
could set zfs recordsize for a given file instead a file system wide
propery (which should be a maximum allowed value). That way, assuming
MySQL, Oracle and other would start using such an extension, Oracle
would ask ZFS to match its recordsize to db_block_size automatically
and OOTB user experience would be much better.





-- 
Best regards,
 Robert Milkowski                            mailto:[EMAIL PROTECTED]
                                       http://milek.blogspot.com

_______________________________________________
zfs-discuss mailing list
zfs-discuss@opensolaris.org
http://mail.opensolaris.org/mailman/listinfo/zfs-discuss

Reply via email to