5 ms·
I'm using sqlite on zfs and btrfs, with transparent compression supported by the file system, the query speed is very good and compression rate also very good.
by aabbcc1241 4y ago
I'm using sqlite on zfs and btrfs, with transparent compression supported by the file system, the query speed is very good and compression rate also very good. (database below 3GB uncompressed, 22% after compressed)
- cmurf 4y agoDid you enable WAL? Any casual comparison in performance between WAL and no-WAL?
- aabbcc1241 4y agoI enable WAL. It performs better than the default (which is to keep a rollback journal)
- usgroup 4y agoWhat do you think about zfs vs btrfs for your use case? Why do you use both?
- aabbcc1241 4y agoI used zfs because I heard it first. But I realized zfs partition cannot shrink in size, one have to copy it to another smaller partition if they have enough spare volume. So I experiment with btrfs on another device and both are working well after some daily usage.
- deleted 4y ago[deleted]