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

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

2017-02-15 Thread Cecil Westerhof
I have several queries which I time with ‘.timer on’. I repeat the queries 350 times. I see a big difference between the minimum and maximum time needed to run the queries. Especially for sys. Like: Number of iterations 350 Timing OR version real: 120.86, min: 0.2710, max: 0.5540, max/min: 2.04