for taking up so much list
bandwidth. I hope others can benefit.
John
--- On Thu, 5/12/11, Pavel Ivanov paiva...@gmail.com wrote:
From: Pavel Ivanov paiva...@gmail.com
Subject: Re: [sqlite] Common Multi-treaded Problem
To: General Discussion of SQLite Database sqlite-users@sqlite.org
Date
should be doing.
Thanks,
John
--- On Thu, 5/12/11, Simon Slavin slav...@bigfraud.org wrote:
From: Simon Slavin slav...@bigfraud.org
Subject: Re: [sqlite] Common Multi-treaded Problem
To: General Discussion of SQLite Database sqlite-users@sqlite.org
Date: Thursday, May 12, 2011, 9:28 PM
On 13
: [sqlite] Common Multi-treaded Problem
To: General Discussion of SQLite Database sqlite-users@sqlite.org
Date: Thursday, May 12, 2011, 9:53 PM
Humm. Resetting each prepared
statement right after use seemed to work. So in review, a
select prepared statement will lock the DB from other
threads
On Fri, 13 May 2011 17:14:32 -0700 (PDT)
John Deal bassd...@yahoo.com wrote:
Again thanks for the information and I apologize for taking up so much list
bandwidth. I hope others can benefit.
Watching this thread was useful to me and I'd like to use this reply to *thank*
Pavel and the
other
On 14 May 2011, at 12:29am, John Deal wrote:
I actually never finalize prepared statements until the DB is closed and not
being used anymore. I reset the prepared statements. For writes (inserts,
updates, etc.) I use explicit transactions with commits (or rollbacks if
errors). I reuse
--- On Fri, 5/13/11, Simon Slavin slav...@bigfraud.org wrote:
From: Simon Slavin slav...@bigfraud.org
Subject: Re: [sqlite] Common Multi-treaded Problem
To: General Discussion of SQLite Database sqlite-users@sqlite.org
Date: Friday, May 13, 2011, 9:05 PM
On 14 May 2011, at 12:29am, John Deal
Hello All,
I have been using SQLite for a couple of years but have never posted to this
list before. I am sure my problem is common and am looking for ideas to solve
it.
I have basically the same situation as this thread:
---
On Wed, Jan 26, 2011 at
On 5/12/2011 12:31 PM, John Deal wrote:
When I allow multiple readers with each thread using a different DB
connection (open with the same flags) and each thread having
exclusive use of its DB connection (no sharing of connections) and if
more than one thread is reading the DB at the same
transactions.
Anyway, thanks for the insight.
John
--- On Thu, 5/12/11, Igor Tandetnik itandet...@mvps.org wrote:
From: Igor Tandetnik itandet...@mvps.org
Subject: Re: [sqlite] Common Multi-treaded Problem
To: sqlite-users@sqlite.org
Date: Thursday, May 12, 2011, 12:35 PM
On 5/12/2011 12:31 PM, John
itandet...@mvps.org
Subject: Re: [sqlite] Common Multi-treaded Problem
To: sqlite-users@sqlite.org
Date: Thursday, May 12, 2011, 12:35 PM
On 5/12/2011 12:31 PM, John Deal
wrote:
When I allow multiple readers with each thread using a
different DB
connection (open with the same flags
wrote:
From: Pavel Ivanov paiva...@gmail.com
Subject: Re: [sqlite] Common Multi-treaded Problem
To: General Discussion of SQLite Database sqlite-users@sqlite.org
Date: Thursday, May 12, 2011, 5:58 PM
Interesting is the impression I
had with prepared statements was the reset was only
, Pavel Ivanov paiva...@gmail.com wrote:
From: Pavel Ivanov paiva...@gmail.com
Subject: Re: [sqlite] Common Multi-treaded Problem
To: General Discussion of SQLite Database sqlite-users@sqlite.org
Date: Thursday, May 12, 2011, 5:58 PM
Interesting is the impression I
had with prepared statements
On 13 May 2011, at 1:33am, John Deal wrote:
Humm. Resetting each prepared statement right after use seemed to work. So
in review, a select prepared statement will lock the DB from other threads
(or is it DB connections?) but not the current thread (or is it DB
connection).
I don't
from other threads
(or is it DB connections?) but not the current thread (or is it DB
connection).
Thanks for the help!
John
--- On Thu, 5/12/11, Pavel Ivanov paiva...@gmail.com wrote:
From: Pavel Ivanov paiva...@gmail.com
Subject: Re: [sqlite] Common Multi-treaded Problem
To: General
If you don't mind, John, for bullying in the discussion...
On Thu, 12 May 2011 17:58:40 -0400
Pavel Ivanov paiva...@gmail.com wrote:
There's no dependency between different prepared statements, but there
is dependency between transactions as they use the same database. And
transaction cannot
Pavel, could you please specify what do you mean by statements in this
transaction? Statements
that were prepared (sqlite3_prepare) or initiated (sqlite3_step) during the
transaction?
Statements that were initiated during the transaction.
Also, is this something that one should
16 matches
Mail list logo