[sqlite] timer in shell.c part II

2006-07-18 Thread Brannon King
Thanks to Carl Clemens, I now have a working shell with a timer in it. I've posted the shell.c on the contrib page along with a Windows exe compiled using VC71. It is built on the latest shell.c version and should compile on Linux as well, though I have not tested that. (My Linux box is down today.

Re: [sqlite] timer in shell.c

2006-07-17 Thread carl clemens
Hi Brannon, Try this: SQLite version 3.3.6 Enter ".help" for instructions sql3> .help .databases List names and files of attached databases .dump ?TABLE? ... Dump the database in an SQL text format .echo ON|OFF Turn command echo on or off .exit Exit this

[sqlite] timer in shell.c

2006-07-17 Thread Brannon King
I'd like to modify the shell.c so that I get an "time taken" output with each query executed (similar to the mysql client). Where would I put the start and stop/print code in shell.c so that I capture the query time but not the time required to output the data to the console? Thanks. _