> On Feb 15, 2017, at 11:47 AM, Cecil Westerhof <cldwester...@gmail.com> wrote: > > But the difference between sys can be almost a factor twenty. What seems very > big to me.
Yup. There is a huge speed difference between the kernel going to the disk/SSD to read from a file, vs. the kernel reading the data out of its buffer cache. That’s why the kernel has buffer caches :) (And those disk reads can be hugely variable. A hard disk can spend 10ms or more seeking, and any medium has bandwidth limits, so other processes’ I/O can greatly slow down your own. I’ve seen filesystem slowdowns of 20x or more shortly after a user logs in when dozens of processes are launching at once.) —Jens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users