Re: [sqlite] Seems that '-cmd .timer on' does not work in non interactive mode

2017-02-15 Thread David Raymond
I'm probably not the best to answer this since I don't know C, but the timing results are printed out in their own special thing. The BEGIN_TIMER and END_TIMER functions only get used in the runOneSqlLine function, and inside the END_TIMER function is where the results actually get printed

[sqlite] Seems that '-cmd .timer on' does not work in non interactive mode

2017-02-15 Thread Cecil Westerhof
I want to do some timings. So I started with the following: sqlite3 -cmd '.timer on' ~/Databases/general.sqlite ' SELECT date , time , usertime , systemtime , idletime , waittime , stolentime , (usertime + systemtime + idletime + waittime + stolentime) AS