Re: [sqlite] .timer explanation anywhere

On Windows the GetProcessTimes Win32 API is used to get the user and kernel (sys) times for the current process since getrusage only exists on unix-like platforms. In all cases the precision and accuracy are limited by the underlying OS timer accuracy. The vfs call to get the current time

Re: [sqlite] .timer explanation anywhere

The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. >-Original Message- >From: sqlite-users On >Behalf Of Jose Isaias Cabrera >Sent: Thursday, 13 February, 2020 06:48 >To: SQLite mailing list >Subject:

[sqlite] .timer explanation anywhere

Greetings. I was searching on sqlite.org for [sqlite command line tool .timer explanation] and found nothing. I also searched on the internet and found an old thread[1] of when .timer had just two entries: CPU Time: user 880.710398 sys 353.260288 And, although, there is some good information

Re: [sqlite] .timer

, 2018 08:17 >To: sqlite-users@mailinglists.sqlite.org >Subject: Re: [sqlite] .timer > >Keith, did you ever get any feedback from ms about this bug? There's >certainly been no windows update that solved the problem. > > > >-- >Sent

Re: [sqlite] .timer

Keith, did you ever get any feedback from ms about this bug? There's certainly been no windows update that solved the problem. -- Sent from: http://sqlite.1065341.n5.nabble.com/ ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] .timer

t: Monday, 18 June, 2018 07:10 >To: SQLite mailing list >Subject: Re: [sqlite] .timer > >I haven't grasped all the fancy memory talk that's been going on >here, but I have one request. Would you try the slowdown tests with a >SQLite version compiled with... >SQLITE_DEFA

Re: [sqlite] .timer

. >-Original Message- >From: sqlite-users [mailto:sqlite-users- >boun...@mailinglists.sqlite.org] On Behalf Of David Raymond >Sent: Monday, 18 June, 2018 07:10 >To: SQLite mailing list >Subject: Re: [sqlite] .timer > >I haven't grasped all the fancy memory talk th

Re: [sqlite] .timer

I haven't grasped all the fancy memory talk that's been going on here, but I have one request. Would you try the slowdown tests with a SQLite version compiled with... SQLITE_DEFAULT_MMAP_SIZE=0 SQLITE_MAX_MMAP_SIZE=0 ...and see if anything changes? I started compiling with those options after

Re: [sqlite] .timer

nt: 17 June 2018 16:02 To: SQLite mailing list<mailto:sqlite-users@mailinglists.sqlite.org> Subject: Re: [sqlite] .timer No, when you use OFFSET you are reading and discarding rows. There is no difference between: select * from t; and discarding all the results except the last row, and, sel

Re: [sqlite] .timer

but only a Stairway to Heaven says a lot about anticipated traffic volume. >-Original Message- >From: sqlite-users [mailto:sqlite-users- >boun...@mailinglists.sqlite.org] On Behalf Of x >Sent: Sunday, 17 June, 2018 06:35 >To: SQLite mailing list >Subject: Re: [sqlite] .timer &

Re: [sqlite] .timer

>Richard was saying he had sped up LIMIT queries in 3.24. I checked this out >and was running LIMIT queries >in sqlite expert (3.23.1) and my app (3.24). >The former was taking 3 times as long to run the queries (not >sure how much >of that was down to improvements or sqlite expert). Anyway, I

Re: [sqlite] .timer

2018-06-04 19:24:41 Enter ".help" for usage hints. Connected to a transient in-memory database. Use ".open FILENAME" to reopen on a persistent database. sqlite> .timer on sqlite> .open mytemp.db sqlite> create table test as -- creates test table with 100 million rows

Re: [sqlite] .timer

-users [mailto:sqlite-users- >boun...@mailinglists.sqlite.org] On Behalf Of x >Sent: Saturday, 16 June, 2018 14:35 >To: SQLite mailing list >Subject: Re: [sqlite] .timer > >Keith, are you rebooting or flushing the memory between these >creates? I only notice the slowdown when they’re

Re: [sqlite] .timer

occurred when the exact same ascending select RowIDs were copied to a vector? From: sqlite-users on behalf of Keith Medcalf Sent: Saturday, June 16, 2018 6:56:19 PM To: SQLite mailing list Subject: Re: [sqlite] .timer I have confirmed that the distributed

Re: [sqlite] .timer

> Yeah, I had a lot of problems with the fileio.c extension after the fsdir > virtual table was added. It needs a >header file "test_windirent.h" to be > available. That was the first thing I had to fix. The compiler couldn’t find the test_windirent.h file. I added the .../sqlite/src path to

Re: [sqlite] .timer

Message- >From: sqlite-users [mailto:sqlite-users- >boun...@mailinglists.sqlite.org] On Behalf Of Keith Medcalf >Sent: Saturday, 16 June, 2018 11:56 >To: SQLite mailing list >Subject: Re: [sqlite] .timer > > >I have confirmed that the distributed shell on sqlite.org display

Re: [sqlite] .timer

ven says a lot about anticipated traffic volume. >-Original Message- >From: sqlite-users [mailto:sqlite-users- >boun...@mailinglists.sqlite.org] On Behalf Of Keith Medcalf >Sent: Friday, 15 June, 2018 18:28 >To: SQLite mailing list >Subject: Re: [sqlite] .timer &g

Re: [sqlite] .timer

a Stairway to Heaven says a lot about anticipated traffic volume. >-Original Message- >From: sqlite-users [mailto:sqlite-users- >boun...@mailinglists.sqlite.org] On Behalf Of x >Sent: Saturday, 16 June, 2018 08:06 >To: SQLite mailing list >Subject: Re: [sqlite] .timer > &g

Re: [sqlite] .timer

I’m trying to add fileio.c to my core_init function so I can investigate if the readfile and writefile functions would help here. I’ve added #include “fileio.c” Inside the core_init function what do I add ? nErr += sqlite3_auto_extension((void(*)())sqlite3_fileio_init); //

Re: [sqlite] .timer

On 16 Jun 2018, at 8:12am, x wrote: > In my travels the only thing I found was a tumbleweed thread on stackoverflow > where an sqlite user was complaining that the first time he ran a query it > took 10 times longer than subsequent executions. He said he raised the point > on this forum but

Re: [sqlite] .timer

<mailto:kmedc...@dessus.com> Sent: 15 June 2018 23:22 Subject: Re: [sqlite] .timer Ok, I have been able to reproduce this but have not figured out what is happening. And you are correct, it appears to be related to "reading backwards" somehow. It is unaffected by the WIN32 cache mode th

Re: [sqlite] .timer

well. --- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. >-Original Message- >From: sqlite-users [mailto:sqlite-users- >boun...@mailinglists.sqlite.org] On Behalf Of Keith Medcalf >Sent: Friday, 15 June, 201

Re: [sqlite] .timer

says a lot about anticipated traffic volume. >-Original Message- >From: sqlite-users [mailto:sqlite-users- >boun...@mailinglists.sqlite.org] On Behalf Of Simon Slavin >Sent: Friday, 15 June, 2018 17:10 >To: SQLite mailing list >Subject: Re: [sqlite] .timer >

Re: [sqlite] .timer

gement code ... --- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. >-Original Message- >From: sqlite-users [mailto:sqlite-users- >boun...@mailinglists.sqlite.org] On Behalf Of Keith Medcalf >Sent: Friday, 15

Re: [sqlite] .timer

On 15 Jun 2018, at 11:21pm, Keith Medcalf wrote: > And you are correct, it appears to be related to "reading backwards" somehow. If you're comparing the two directions of reading the same file, there are ways to fake out Windows' read-ahead tricks and see if they're what's messing up your

Re: [sqlite] .timer

sqlite-users [mailto:sqlite-users- >boun...@mailinglists.sqlite.org] On Behalf Of x >Sent: Friday, 15 June, 2018 10:53 >To: SQLite mailing list >Subject: Re: [sqlite] .timer > >Thanks Keith. I did look on the performance page but didn’t realise >clicking the items on the l

Re: [sqlite] .timer

Thanks Keith. I did look on the performance page but didn’t realise clicking the items on the left brought up different info. I am on windows 10 pro. I haven’t had time to try creating the ‘personalised’ sqlite3.exe so the following relates to my own app run under the original conditions (i.e.

Re: [sqlite] .timer

lf Of Keith Medcalf >Sent: Friday, 15 June, 2018 07:56 >To: SQLite mailing list >Subject: Re: [sqlite] .timer > > >You are using Windows 10? It is on the "Performance" tab, select the >wee graph on the right for "Memory". In the detail, right underneath

Re: [sqlite] .timer

n Behalf Of curmudgeon >Sent: Friday, 15 June, 2018 07:13 >To: sqlite-users@mailinglists.sqlite.org >Subject: Re: [sqlite] .timer > >PS I can't find 'cache' in task manager. > > > >-- >Sent from: http://sqlite.1065341.n5.nabble.com/ >

Re: [sqlite] .timer

>You spoon fed me on a previous thread how to load extensions using a >core_init function placed at the end of the sqlite3.c code. I do have >the series.c in my core_init so it is available to me and works fine >in my cpp code. I don’t see how that relates to sqlite3.exe though. >How do you get

Re: [sqlite] .timer

PS I can't find 'cache' in task manager. -- Sent from: http://sqlite.1065341.n5.nabble.com/ ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] .timer

qlite.org] On Behalf Of x >Sent: Friday, 15 June, 2018 02:06 >To: SQLite mailing list >Subject: Re: [sqlite] .timer > >Keith, I can find no instance of 2966 in my sqlite.c code. I have >found the code you mentioned > > > > if( isDelete ){ > >#if SQLITE_OS_W

Re: [sqlite] .timer

2 MB, not 2 GB. -Original Message- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Warren Young Sent: Thursday, June 14, 2018 5:54 PM To: SQLite mailing list Subject: Re: [sqlite] .timer By default, SQLite will only cache a smidge under 2 GiB, so

Re: [sqlite] .timer

mailing list >Subject: Re: [sqlite] .timer > >>Actually I cannot reproduce even if I turn off forced RANDOM mode >for the cache, reduce the size of the >sqlite3 cache to the default, >and make sure the temp_store is on disk (not my default). > >Are you rebooting or flushi

Re: [sqlite] .timer

lf Of x >Sent: Friday, 15 June, 2018 02:06 >To: SQLite mailing list >Subject: Re: [sqlite] .timer > >Keith, I can find no instance of 2966 in my sqlite.c code. I have >found the code you mentioned > > > > if( isDelete ){ > >#if SQLITE_OS_WINCE > >

Re: [sqlite] .timer

>Actually I cannot reproduce even if I turn off forced RANDOM mode for the >cache, reduce the size of the >sqlite3 cache to the default, and make sure the >temp_store is on disk (not my default). Are you rebooting or flushing the cache between the commands? I don’t have any problems (except

Re: [sqlite] .timer

To: SQLite mailing list Subject: Re: [sqlite] .timer Yes. Search your sqlite3.c for #2966 (there is only one instance and it is in the winOpen function, somewhere around line 44847). The code that is there will be an #ifdef that forces RANDOM_ACCESS only for WINCE. Just change it so that you

Re: [sqlite] .timer

a Stairway to Heaven says a lot about anticipated traffic volume. >-Original Message- >From: sqlite-users [mailto:sqlite-users- >boun...@mailinglists.sqlite.org] On Behalf Of x >Sent: Friday, 15 June, 2018 00:50 >To: SQLite mailing list >Subject: Re: [sqlite] .timer &

Re: [sqlite] .timer

a lot about anticipated traffic volume. >-Original Message- >From: sqlite-users [mailto:sqlite-users- >boun...@mailinglists.sqlite.org] On Behalf Of x >Sent: Friday, 15 June, 2018 00:50 >To: SQLite mailing list >Subject: Re: [sqlite] .timer > >Thanks for all the repli

Re: [sqlite] .timer

? From: sqlite-users on behalf of Keith Medcalf Sent: Thursday, June 14, 2018 10:09:50 PM To: SQLite mailing list Subject: Re: [sqlite] .timer See the following web page for how the default "Microsoft Magical Mystery Cache Mode" works on Windows. The term "Intelli

Re: [sqlite] .timer

On Jun 14, 2018, at 12:31 PM, x wrote: > > It is Windows Defender I’m using So does the symptom go away when you turn Defender off? I would not expect it to, but let’s close the loop on this, okay? > a ms surface pro 4 with 16 GB ram and 512 GB SSD I think we can provisionally rule out

Re: [sqlite] .timer

On 14 Jun 2018, at 10:04pm, Simon Slavin wrote: > Now do exactly the same test, but have the file stored on a USB Flash drive > instead of the boot volume. You should be able to do something like > > .open d:\MyTemp.db > > See how this influences any change. Oh, also try the same drive but

Re: [sqlite] .timer

way to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. >-Original Message- >From: sqlite-users [mailto:sqlite-users- >boun...@mailinglists.sqlite.org] On Behalf Of Keith Medcalf >Sent: Thursday, 14 June, 2018 14:16 >To: SQLite mailing

Re: [sqlite] .timer

On 14 Jun 2018, at 7:31pm, x wrote: > Why is using ‘RowID desc’ so much slower than ‘RowID asc’ after a ‘reboot’? I > get the impression Windows is caching the pages from the ‘desc’ but not the > ‘asc’ and that’s what’s slowing it down. On this particular journey I’ve come > across tables

Re: [sqlite] .timer

ays a lot about anticipated traffic volume. >-Original Message- >From: sqlite-users [mailto:sqlite-users- >boun...@mailinglists.sqlite.org] On Behalf Of x >Sent: Thursday, 14 June, 2018 12:31 >To: SQLite mailing list >Subject: Re: [sqlite] .timer > >

Re: [sqlite] .timer

ments SQLite version 3.24.0 2018-06-04 19:24:41 Enter ".help" for usage hints. Connected to a transient in-memory database. Use ".open FILENAME" to reopen on a persistent database. sqlite> .timer on sqlite> .open MyTemp.db -- open empty DB sqlite> .shell FlushMem Avai

Re: [sqlite] .timer

On Jun 14, 2018, at 11:00 AM, Bob Friesenhahn wrote: > > On Thu, 14 Jun 2018, Warren Young wrote: > >> On Jun 14, 2018, at 8:36 AM, x wrote: >>> >>> It is indeed windows Ryan and at times we’re talking 120 secs versus 30 + >>> 14. >> >> Are you using Windows Defender or some other

Re: [sqlite] .timer

On Thu, 14 Jun 2018, Warren Young wrote: On Jun 14, 2018, at 8:36 AM, x wrote: It is indeed windows Ryan and at times we’re talking 120 secs versus 30 + 14. I can think of two good possibilities: 1. Are you using Windows Defender or some other antimalware solution? If it’s a third-party

Re: [sqlite] .timer

On Jun 14, 2018, at 8:36 AM, x wrote: > > It is indeed windows Ryan and at times we’re talking 120 secs versus 30 + 14. I can think of two good possibilities: 1. Are you using Windows Defender or some other antimalware solution? If it’s a third-party product, some of those are very

Re: [sqlite] .timer

ailinglists.sqlite.org >Subject: Re: [sqlite] .timer > >On 06/14/2018 03:08 PM, Simon Slavin wrote: >> On 14 Jun 2018, at 8:33am, x wrote: >> >>> Could someone describe what the return values real, user and sys >mean and why there’s sometimes a big difference betwe

Re: [sqlite] .timer

On 06/14/2018 03:08 PM, Simon Slavin wrote: On 14 Jun 2018, at 8:33am, x wrote: Could someone describe what the return values real, user and sys mean and why there’s sometimes a big difference between real and the sum of user & sys?. [The following is simplified for clarity.] 'real' --

Re: [sqlite] .timer

a light it shows sqlite in. From: sqlite-users on behalf of R Smith Sent: Thursday, June 14, 2018 10:34:58 AM To: sqlite-users@mailinglists.sqlite.org Subject: Re: [sqlite] .timer On 2018/06/14 10:28 AM, x wrote: > Thanks for the detail Simon.

Re: [sqlite] .timer

On 2018/06/14 10:28 AM, x wrote: Thanks for the detail Simon. I’m consistently getting some really big differences where user + sys < real. I’ll post another thread on it but it does seem to be something windows is doing rather than sqlite. If sys + user << real  -  you are probably running

Re: [sqlite] .timer

On 14 Jun 2018, at 9:28am, x wrote: > Thanks for the detail Simon. I’m consistently getting some really big > differences where user + sys < real. I’ll post another thread on it but it > does seem to be something windows is doing rather than sqlite. You're welcome. It's barely worth the post

Re: [sqlite] .timer

ent: Thursday, June 14, 2018 9:08:31 AM To: SQLite mailing list Subject: Re: [sqlite] .timer On 14 Jun 2018, at 8:33am, x wrote: > Could someone describe what the return values real, user and sys mean and why > there’s sometimes a big difference between real and the sum of u

Re: [sqlite] .timer

On 14 Jun 2018, at 8:33am, x wrote: > Could someone describe what the return values real, user and sys mean and why > there’s sometimes a big difference between real and the sum of user & sys?. [The following is simplified for clarity.] 'real' -- Elapsed time between the start and end of the

[sqlite] .timer

Could someone describe what the return values real, user and sys mean and why there’s sometimes a big difference between real and the sum of user & sys?. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] .timer command missing from CLI ?

On 15 Feb 2017, at 7:22pm, Simon Slavin <slav...@bigfraud.org> wrote: > sqlite> .changes on > sqlite> .timer on > Error: unknown command or invalid arguments: "timer". Enter ".help" for help Fix now committed and distributed to beta-testers. The co

Re: [sqlite] .timer command missing from CLI ?

On 17 Feb 2017, at 9:09pm, Scott Perry wrote: > In the future it would be most appreciated if problems with Apple's version > of SQLite were reported by Radar , doubly so > for pre-release versions of operating systems where the issues can be

Re: [sqlite] .timer command missing from CLI ?

On Feb 15, 2017, at 11:46 AM, Simon Slavin wrote: > On 15 Feb 2017, at 7:39pm, Richard Hipp wrote: >> Are you saying it is the one built into MacOS - not one you obtained >> from https://www.sqlite.org/download.html? If so, can you provide me >> with

Re: [sqlite] .timer command missing from CLI ?

On 15 Feb 2017, at 7:39pm, Richard Hipp wrote: > Are you saying it is the one built into MacOS - not one you obtained > from https://www.sqlite.org/download.html? If so, can you provide me > with details of what OS version you are running, please? Answered privately because

Re: [sqlite] .timer command missing from CLI ?

On 2/15/17, Simon Slavin wrote: > > On 15 Feb 2017, at 7:17pm, Ben Newberg wrote: > >> Is that a homebrew version of 3.16.0? > > Not in any way. It’s one which comes with a very recent version of macOS: Are you saying it is the one built into MacOS

Re: [sqlite] .timer command missing from CLI ?

s causing the problem. sqlite> .changes on sqlite> .timer on Error: unknown command or invalid arguments: "timer". Enter ".help" for help Simon. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mail

Re: [sqlite] .timer command missing from CLI ?

Is that a homebrew version of 3.16.0? SQLite version 3.16.0 2017-01-02 11:57:58 Enter ".help" for usage hints. Connected to a transient in-memory database. Use ".open FILENAME" to reopen on a persistent database. sqlite> .timer on sqlite> 3.15.1 was released o

Re: [sqlite] .timer command missing from CLI ?

On 2/15/17, Simon Slavin <slav...@bigfraud.org> wrote: > simon$ sqlite3 ~/Desktop/fred.sql > SQLite version 3.16.0 2016-11-04 19:09:39 > Enter ".help" for usage hints. > sqlite> .timer on > Error: unknown command or invalid arguments: "timer". Enter

[sqlite] .timer command missing from CLI ?

simon$ sqlite3 ~/Desktop/fred.sql SQLite version 3.16.0 2016-11-04 19:09:39 Enter ".help" for usage hints. sqlite> .timer on Error: unknown command or invalid arguments: "timer". Enter ".help" for help sqlite> .timer off Error: unknown command or inval

Re: [sqlite] '.timer on' in the shell tool

ok 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 she

Re: [sqlite] '.timer on' in the shell tool

Hi, Simon. > 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 ? > System time may be much greater if it involves a

Re: [sqlite] '.timer on' in the shell tool

On Mon, Dec 15, 2014 at 10:24 AM, Simon Slavin wrote: > > On 15 Dec 2014, at 9:20am, Donald Shepherd > wrote: > > - Units are seconds. > > - IIRC user time is time spent in SQLite code, sys time is time spent in > > system (OS) calls. Both can

Re: [sqlite] '.timer on' in the shell tool

On 15 Dec 2014, at 9:20am, Donald Shepherd wrote: > - Units are seconds. > - IIRC user time is time spent in SQLite code, sys time is time spent in > system (OS) calls. Both can vary from run to run and (at least in my > testing) sys time tends to vary based off

Re: [sqlite] '.timer on' in the shell tool

Let's see if I remember my notes from work ok at home: - Units are seconds. - IIRC user time is time spent in SQLite code, sys time is time spent in system (OS) calls. Both can vary from run to run and (at least in my testing) sys time tends to vary based off system usage. If you want the best

[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

[sqlite] .timer with windows cli

Kim Boulton wrote: > Is there a compiled v3.6.11 sqlite3.exe with the .timer facility > enabled. I don't think so for windows -- but I've been wrong many times before. ;) [From shell.c] #if !defined(_WIN32) && !defined(WIN32) && . . . . #include #include . . . . . . . . #define BEGIN_TIMER

[sqlite] .timer with windows cli

Kim Boulton wrote: > Is there a compiled v3.6.11 sqlite3.exe with the .timer facility > enabled. Not for windows (I believe) as follows: [From shell.c] #if !defined(_WIN32) && !defined(WIN32) && . . . #include #include . . . . . . #define BEGIN_TIMER beginTimer() #define

Re: [sqlite] .timer with windows cli

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Kim Boulton wrote: > However, how do you get the thing to compile with MinGW? You tried way too hard :-) Use the .tar.gz version of the amalgamation as it includes the shell source code (the .zip doesn't). Then this command works (no need to use

Re: [sqlite] .timer with windows cli

Roger, Thanks for that. However, how do you get the thing to compile with MinGW? I Installed mingw and msys, fixed a problem with the msys batch file, fixed the paths to mingw so that gcc was found, did a compile and then a make but get linker failures at that point. To get this far I

Re: [sqlite] .timer with windows cli

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Kim Boulton wrote: > Anywhere I can download one would be nice. You can get the free MinGW compiler from http://www.mingw.org - it is what I use to compile SQLite and other code on Windows. MinGW is a Windows port of gcc plus other GNU tools. Roger

[sqlite] .timer with windows cli

Hello, Is there a compiled v3.6.11 sqlite3.exe with the .timer facility enabled. I don't have a C compiler on this machine. Anywhere I can download one would be nice. Thanks kim ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] timer in shell.c part II

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

Re: [sqlite] timer in shell.c

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