Re: [sqlite] Difference between min and max time, especially for sys

2017-02-16 Thread Cecil Westerhof
2017-02-16 19:31 GMT+01:00 Jens Alfke : > > > On Feb 15, 2017, at 11:47 AM, Cecil Westerhof > 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

Re: [sqlite] Difference between min and max time, especially for sys

2017-02-16 Thread Jens Alfke
> On Feb 15, 2017, at 11:47 AM, Cecil Westerhof 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

Re: [sqlite] Difference between min and max time, especially for sys

2017-02-15 Thread Simon Slavin
On 15 Feb 2017, at 7:47pm, Cecil Westerhof wrote: > So the difference between minimum and maximum is about a factor two. What > seems reasonable to me. But the difference between sys can be almost a > factor twenty. What seems very big to me. Caching affects sys. Might