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 user: 110.10, min: 0.2360, max: 0.4760, max/min: 2.02 sys : 9.87, min: 0.0040, max: 0.0640, max/min: 16.00
Timing ABS version real: 108.96, min: 0.2730, max: 0.4850, max/min: 1.78 user: 97.67, min: 0.2320, max: 0.3720, max/min: 1.60 sys : 10.67, min: 0.0080, max: 0.0680, max/min: 8.50 Timing NOT BETWEEN version GOT A ZERO VALUE FOR SYS!!! real: 106.51, min: 0.2610, max: 0.4830, max/min: 1.85 user: 95.64, min: 0.2160, max: 0.4160, max/min: 1.93 sys : 10.14, min: 0.0040, max: 0.0760, max/min: 19.00 Timing NOT BETWEEN version 2 GOT A ZERO VALUE FOR SYS!!! real: 113.77, min: 0.2770, max: 0.5370, max/min: 1.94 user: 101.76, min: 0.2320, max: 0.4520, max/min: 1.95 sys : 11.24, min: 0.0040, max: 0.0680, max/min: 17.00 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. Also it looks like SQLite suggests a precision it does not have. It shows four digits after the point, but it looks like that the smallest value greater as zero is 0.004. So why does SQLite not show three digits after the point? -- Cecil Westerhof _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users