On 19 Aug 2015, at 3:27am, Paolo Bolzoni <paolo.bolzoni.brown at gmail.com> wrote:
> coping the sqlite db on an external disk connected via usb3 > and formatted with Ntfs actually does the pragma quick_check in little > more than 20 seconds and pragma integrity_check in 5 minutes. Those times are completely typical for SQLite. Those are the sort of times I'd expect to see. > So I think it is not an hardware problem, but Zfs messes up somewhat. > Is there any known disagreement between Zfs and sqlite? Over the years SQLite has revealed bugs in various versions of ZFS. However, I'm not aware of any problems with up-to-date versions of ZFS. > In fact I have > this feeling that my system is working fine in everything a part of > sqlite. > I read in the man that recordsize could be relevant. You might be able to improve your times by 50% with judicious choices of tweaks. But your original times strongly suggest disk problems of some kind. The current theory seems to be a ZFS formatting fault, but I know nothing about ZFS in real use so I don't know what to do about checking that. Hmm. Would it be possible to format an external drive in ZFS and try the operations on files stored on that ? Simon.
