--- On Thu, 9/9/10, Kees Nuyt wrote:
> From: Kees Nuyt
> 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
>
> wrote:
>
>
--- On Thu, 9/9/10, Black, Michael (IS) wrote:
> From: Black, Michael (IS)
> Subject: Re: [sqlite] In memory database and locking.
> To: "General Discussion of SQLite Database"
> Date: Thursday, September 9, 2010, 9:16 AM
> I've never seen an application
On Wed, 8 Sep 2010 21:03:05 -0700 (PDT), Hemant Shah
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() o
is
never going to keep up with a gigabit interface.
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Hemant Shah
Sent: Wednesday, September 08, 2010 10:55 PM
To: sqlite-users@sqlite.org
Subject: EXTERNAL:[sqlite] In memory database
--- On Thu, 9/9/10, Simon Slavin wrote:
From: Simon Slavin
Subject: Re: [sqlite] In memory database and locking.
To: "General Discussion of SQLite Database"
Date: Thursday, September 9, 2010, 8:24 AM
On 9 Sep 2010, at 4:55am, Hemant Shah wrote:
> The other process wakes up eve
On 9 Sep 2010, at 4:55am, Hemant Shah wrote:
> The other process wakes up every 60 seconds and deletes all row whose
> timestamp columns is less then (current timestamp - 60). The timestamp is
> number of seconds since epoch.
Do you do this using a single DELETE FROM command ? Do you have an
Quoth Hemant Shah , on 2010-09-08 20:55:29 -0700:
> Both of these processes are sibling and have same database
> handle.
No, don't do that.
http://www.sqlite.org/faq.html#q6
And :memory: databases are not shared between processes, AFAIK.
Why are there two processes anyway? You could just use o
vacuum is a no-op for in memory database.
Hemant Shah
E-mail: hj...@yahoo.com
--- On Wed, 9/8/10, Woody & Yuni Ho wrote:
From: Woody & Yuni Ho
Subject: Re: [sqlite] In memory database and locking.
To: "General Discussion of SQLite Database"
Date: Wednesday, September 8, 20
emory database and locking.
I forgot to mention, that I have set pragma journal_mode to off and for every
insert I doprepare -> step -> finalize -> COMMIT.
Hemant Shah
E-mail: hj...@yahoo.com
--- On Wed, 9/8/10, Hemant Shah wrote:
From: Hemant Shah
Subject: [sqlite] In memory databa
I forgot to mention, that I have set pragma journal_mode to off and for every
insert I doprepare -> step -> finalize -> COMMIT.
Hemant Shah
E-mail: hj...@yahoo.com
--- On Wed, 9/8/10, Hemant Shah wrote:
From: Hemant Shah
Subject: [sqlite] In memory database and locking.
To: sql
Folks,
I am trying to write an application that reads packets from the network and
inserts it into sqlite database, I have a unique key which is combination of
couple of columns. I want to find re-transmitted packets so I rely on the fact
that if I violate unique key constraint then I have found
11 matches
Mail list logo
