On Sat, Sep 20, 2014 at 1:34 PM, <to...@acm.org> wrote: > In trying to see if the new version breaks any of my queries, I ran > several of them repeatedly, and they all appear to have produced the > expected output. > > The only thing I noticed which maybe of interest in relation to speed > performance was (with .timer on) that although the first two run time > numbers (real & user) were consistently smaller in 3.8.7 (when compared to > 3.8.6), the third number (sys) was consistently higher (or same in one > occasion). I guess the first number is the actual time (in seconds) it > took to run the query. I don't even know what the 2nd and 3rd numbers > represent, and how or if they maybe related to the first one. Is that > increase in sys to be expected? >
Thanks for the report. I think the increased system time is harmless, but I want to investigate further to be sure. Except right now I'm preoccupied with Mr. Xu's new bug. So please remind me next week if I don't bring this up again. :-) What OS are you using? Can you share your database and test script with us? > > A few examples from many more I tried that all follow the same pattern > (same query & database in each case): > > 3.8.6: Run Time: real 2.434 user 2.386815 sys 0.000000 > 3.8.7: Run Time: real 1.856 user 1.778411 sys 0.062400 > --- > 3.8.6: Run Time: real 584.465 user 560.293192 sys 1.638011 > 3.8.7: Run Time: real 518.227 user 430.469159 sys 53.617544 > --- > 3.8.6: Run Time: real 2.449 user 2.340015 sys 0.046800 > 3.8.7: Run Time: real 1.935 user 1.794012 sys 0.046800 > > (Thank you for two great solutions I use daily -- SQLite3 and Fossil) > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users