Units are "CPU Seconds". "user" time is spent within user code, i.e. SQLite, "sys" time is spent within system calls, i.e. reading/writing files.
The balance between the times depends on various parameters, including the state of the disc cache and the complexity of your INSERT...SELECT statements. Performing complex calculations to arrive at field values will tend to increase user time. Performing complex joins will tend to increase sys time as more data needs to be read from file. It is hard to tell without the schemata and the SQL involved. Look at the output from EXPLAIN and EXPLAIN QUERY PLAN to get an idea of the work involved. -----Ursprüngliche Nachricht----- Von: Simon Slavin [mailto:slav...@bigfraud.org] Gesendet: Montag, 15. Dezember 2014 10:12 An: General Discussion of SQLite Database Betreff: [sqlite] '.timer on' in the shell tool Okay. I used '.timer on' in the shell tool. SQLite 3.7.13, if it matters. Here are two sample lines I got in response to different INSERT ... SELECT commands: CPU Time: user 880.710398 sys 353.260288 CPU Time: user 5073.001124 sys 11609.266484 The two commands were issued one after another on a computer which was otherwise idle. Question 1: What are the units ? Question 2: I would have expected consistency in that user time was always greater than system time. Or perhaps the other way around. Why is a different one greater for the two examples ? Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___________________________________________ Gunter Hick Software Engineer Scientific Games International GmbH FN 157284 a, HG Wien Klitschgasse 2-4, A-1130 Vienna, Austria Tel: +43 1 80100 0 E-Mail: h...@scigames.at This communication (including any attachments) is intended for the use of the intended recipient(s) only and may contain information that is confidential, privileged or legally protected. Any unauthorized use or dissemination of this communication is strictly prohibited. If you have received this communication in error, please immediately notify the sender by return e-mail message and delete all copies of the original communication. Thank you for your cooperation. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
