On 19 Aug 2015, at 10:46am, Paolo Bolzoni <paolo.bolzoni.brown at gmail.com> wrote:
> As you might have guessed from the timezone I am not at home atm, so I > do not have spare external disks. > However, I do have an expendable 16BG usb stick so I tried on that. > > First I formatted it using zfs and I did the Pragma quick_check; I > killed it after 40 minutes. > Secondly I formatted it using ext4 and the Pragma quick_check; it > finished in about 25 minutes. > > Now, I am trying again with zfs. But I think it already shows > something is indeed wrong. Just by itself, the above information is significant to the SQLite team. Perhaps when you have had a chance to confirm it a new thread can be started called 'SQLite database on ZFS is very slow'. This should pull any ZFS experts out of the woodwork. Unfortunately I am not one of them. Simon.
