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

2017-02-15 Thread David Raymond
rg] On Behalf Of Cecil Westerhof Sent: Wednesday, February 15, 2017 7:05 AM To: SQLite mailing list Subject: [sqlite] Seems that '-cmd .timer on' does not work in non interactive mode I want to do some timings. So I started with the following: sqlite3 -cmd '.timer on' ~/D

[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 totaltim