On Mon, Dec 15, 2014 at 10:24 AM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 15 Dec 2014, at 9:20am, Donald Shepherd <donald.sheph...@gmail.com> > wrote: > > - Units are seconds. > > - IIRC user time is time spent in SQLite code, sys time is time spent in > > system (OS) calls. Both can vary from run to run and (at least in my > > testing) sys time tends to vary based off system usage. > > > > If you want the best "real" time results, a later version of the command > > line also includes a "real" time that represents actual time elapsed but > it > > also has updated query planning IIRC. > > Okay. That explains that. What I really needed was wall time, which I > guess this version doesn't have. Not to worry. I don't need to know it, > it would just have been interesting.
One final note: User time can exceed wall time if parallelism is involved (i.e. multi-threading), which I guess is now possible with the new MT-sorter. --DD _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users