--- On Thu, 9/9/10, Kees Nuyt <k.n...@zonnet.nl> wrote:
> From: Kees Nuyt <k.n...@zonnet.nl>
> Subject: Re: [sqlite] In memory database and locking.
> To: sqlite-users@sqlite.org
> Date: Thursday, September 9, 2010, 11:48 AM
> On Wed, 8 Sep 2010 21:03:05 -0700
> (PDT), Hemant Shah
> <hj...@yahoo.com>
> wrote:
>
> > I forgot to mention, that I have set pragma
> journal_mode to off
> > and for every insert I do prepare -> step ->
> finalize -> COMMIT.
>
> That's a weird sequence.
> Because you use the same statement all the time, you only
> have to prepare() once, and then for every INSERT:
> bind(); step(); reset(); clear_bindings();
>
> Also, COMMIT doesn't make sense without a BEGIN.
> For speed, wrap several (or even many) INSERTs in one
> BEGIN
> / COMMIT pair.
> Without BEGIN; COMMIT, every single INSERT is a
> transaction
> by itself.
>
Where can I find good example of this. I have not found a good example
of insert and select. I am used to DB2 and Oracle, this is first time I am
working with sqlite.
> Finalize at program exit (or not at all).
> --
> ( Kees Nuyt
> )
> c[_]
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Hemant Shah
E-mail: hj...@yahoo.com
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users