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 totaltime FROM vmstat WHERE totaltime < 99 OR totaltime > 101 ;'
This does display the query result, but not the runtime. At the moment I just start sqlite with: sqlite3 -cmd '.timer on' ~/Databases/general.sqlite and then interactively enter: SELECT date , time , usertime , systemtime , idletime , waittime , stolentime , (usertime + systemtime + idletime + waittime + stolentime) AS totaltime FROM vmstat WHERE totaltime < 99 OR totaltime > 101 ; I get beside the query result also: Run Time: real 0.298 user 0.264000 sys 0.036000 What is happening here? I got around it with: sqlite3 -batch -cmd '.timer on' ~/Databases/general.sqlite <<EOT SELECT date , time , usertime , systemtime , idletime , waittime , stolentime , (usertime + systemtime + idletime + waittime + stolentime) AS totaltime FROM vmstat WHERE totaltime < 99 OR totaltime > 101 ; EOT -- Cecil Westerhof _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
