On Jun 10, 2008, at 10:18 AM, Shailesh Birari wrote:
> Richard,
> Just to go one step ahead, If there are independent connections, do
> you
> mean that there can exist multiple transactions at the same time? I
> think not since the first transaction (write) will exclusively lock
> the
>
abase
> Subject: Re: [sqlite] Database locked error, while deleting
>
>
> On Jun 10, 2008, at 7:36 AM, Sabyasachi Ruj wrote:
>
> > Hi,
> >
> > I have a very big table with around 40,00, 000 rows. 4 columns. 220
> > MB.
> >
> > Now, I have tw
Our PRAGMA cache_size = 4000.
Is there any recommended way to calculate the cache size needed?
On Tue, Jun 10, 2008 at 5:29 PM, Igor Tandetnik <[EMAIL PROTECTED]> wrote:
> "Sabyasachi Ruj" <[EMAIL PROTECTED]>
> wrote in message
> news:[EMAIL PROTECTED]<[EMAIL PROTECTED]>
> > Now, I have two
We are using two different connections to sqlite for these two different
threads.
So, we are not sharing the connection in SELECT and the DELETE thread.
On Tue, Jun 10, 2008 at 5:28 PM, D. Richard Hipp <[EMAIL PROTECTED]> wrote:
>
> On Jun 10, 2008, at 7:36 AM, Sabyasachi Ruj wrote:
>
> > Hi,
>
"Sabyasachi Ruj" <[EMAIL PROTECTED]>
wrote in message
news:[EMAIL PROTECTED]
> Now, I have two threads:-
> Thread1: Is deleting 7,00, 000 rows from the table.
> Thread2: Is doing SELECT on the same table.
>
> Now the problem is sometimes the sqlite3_prepare for the SELECT query
> is failing with
On Jun 10, 2008, at 7:50 AM, Alex Katebi wrote:
> There can only be one prepare per table at a time. The first prepare
> has to
> be finalized before another one. Table is locked by the first
> prepare until
> finalized.
>
Actually, there is no limit on the number of prepared statements on
There can only be one prepare per table at a time. The first prepare has to
be finalized before another one. Table is locked by the first prepare until
finalized.
On Tue, Jun 10, 2008 at 7:36 AM, Sabyasachi Ruj <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I have a very big table with around 40,00, 000
Hi,
I have a very big table with around 40,00, 000 rows. 4 columns. 220 MB.
Now, I have two threads:-
Thread1: Is deleting 7,00, 000 rows from the table.
Thread2: Is doing SELECT on the same table.
Now the problem is sometimes the sqlite3_prepare for the SELECT query is
failing with SQLITE_BUSY
8 matches
Mail list logo