On 7 August 2018 at 21:25, David Raymond wrote:
> Correct.
>
> In rollback journal mode when one connection says "I'm ready to write now"
> it blocks any new transactions from being made, but it can't do anything
> about existing read transactions. It has to wait for them to finish their
> reads
ando Falauto
>Sent: Tuesday, 7 August, 2018 05:55
>To: SQLite mailing list
>Subject: [sqlite] Database locks
>
>Hi,
>
>I'm trying to implement a logging system based on SQLite, using
>python3
>package apsw.
>There's one process constantly writing and another
Of David Raymond
>Sent: Tuesday, 7 August, 2018 11:13
>To: SQLite mailing list
>Subject: Re: [sqlite] Database locks
>
>I think what he's saying is "my reads are slow, and I don't want them
>to block my writes" which would mean he use WAL mode.
>
>i.e. the
om: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On
Behalf Of Simon Slavin
Sent: Tuesday, August 07, 2018 12:56 PM
To: SQLite mailing list
Subject: Re: [sqlite] Database locks
On 7 Aug 2018, at 3:04pm, Gerlando Falauto wrote:
> What might happen in my case is that rea
On 7 Aug 2018, at 3:04pm, Gerlando Falauto wrote:
> What might happen in my case is that reads could take a very long time to
> consume/process all the data (30s for instance), and I believe the lock is
> held until all data is consumed.
> I believe in that case the read would see all the data
On Tue, Aug 7, 2018 at 3:28 PM, Simon Slavin wrote:
> On 7 Aug 2018, at 1:54pm, Gerlando Falauto
> wrote:
>
> > I just realized I'm using default settings... perhaps I should use WAL
> mode
> > instead?
>
> How important is it to you that SELECT gets up-to-date information ? If a
> read
On 7 Aug 2018, at 1:54pm, Gerlando Falauto wrote:
> I just realized I'm using default settings... perhaps I should use WAL mode
> instead?
How important is it to you that SELECT gets up-to-date information ? If a read
happens at the same time as a write:
Normal mode: SELECT waits until the
linglists.sqlite.org] On
Behalf Of Gerlando Falauto
Sent: Tuesday, August 07, 2018 8:54 AM
To: SQLite mailing list
Subject: Re: [sqlite] Database locks
I just realized I'm using default settings... perhaps I should use WAL mode
instead?
Thanks,
Gerlando
On Tue, Aug 7, 2018 at 2:22 PM, Gerlando F
I just realized I'm using default settings... perhaps I should use WAL mode
instead?
Thanks,
Gerlando
On Tue, Aug 7, 2018 at 2:22 PM, Gerlando Falauto wrote:
> Hi Simon,
> than you for your answer.
>
> On Tue, Aug 7, 2018 at 2:09 PM, Simon Slavin wrote:
>
>> On 7 Aug 2018, at 12:55pm,
On 7 Aug 2018, at 1:22pm, Gerlando Falauto wrote:
> Hmm... are you saying the writer could potentially block for up to 10
> seconds?
I should have been clearer. The 10 second time is purely for diagnostic
purposes, to see if the error goes away. It was chosen to be far longer than
any
Hi Simon,
than you for your answer.
On Tue, Aug 7, 2018 at 2:09 PM, Simon Slavin wrote:
> On 7 Aug 2018, at 12:55pm, Gerlando Falauto
> wrote:
>
> > I'm trying to implement a logging system based on SQLite, using python3
> > package apsw.
> > There's one process constantly writing and another
On 7 Aug 2018, at 12:55pm, Gerlando Falauto wrote:
> I'm trying to implement a logging system based on SQLite, using python3
> package apsw.
> There's one process constantly writing and another one reading.
> From time to time I get an exception from the writer, complaining the
> database is
Hi,
I'm trying to implement a logging system based on SQLite, using python3
package apsw.
There's one process constantly writing and another one reading.
From time to time I get an exception from the writer, complaining the
database is locked.
I'm pretty sure there's no other process writing, and
On 3/7/06, Stefan de Konink <[EMAIL PROTECTED]> wrote:
> On Tue, 7 Mar 2006, Firman Wandayandi wrote:
>
> > On 3/7/06, Stefan de Konink <[EMAIL PROTECTED]> wrote:
> > > Hello,
> > >
> > >
> > > We are running SQLite 2.8.16 together with PHP5 on Linux. And it runs
> > > our TV Newspaper System. It
On Tue, 7 Mar 2006, Firman Wandayandi wrote:
> On 3/7/06, Stefan de Konink <[EMAIL PROTECTED]> wrote:
> > Hello,
> >
> >
> > We are running SQLite 2.8.16 together with PHP5 on Linux. And it runs
> > our TV Newspaper System. It was running on a PIII-1GHz but due some
> > shifts for rendering
On 3/7/06, Stefan de Konink <[EMAIL PROTECTED]> wrote:
> Hello,
>
>
> We are running SQLite 2.8.16 together with PHP5 on Linux. And it runs
> our TV Newspaper System. It was running on a PIII-1GHz but due some
> shifts for rendering performance increase (Inkscape SVG -> PNG) we moved
> the
Hello,
We are running SQLite 2.8.16 together with PHP5 on Linux. And it runs
our TV Newspaper System. It was running on a PIII-1GHz but due some
shifts for rendering performance increase (Inkscape SVG -> PNG) we moved
the complete application to an AMD64.
The last weeks it seems the
17 matches
Mail list logo