I am old database programmer that just came across SQLite and am working on
a small project for a PVR that uses SQLite as it's db provider. I try
specifying a UNC path to the database for the datasource in the connection
string and I get the following error, "unable to open database file". .
No. Apache uses a worker process pool where each forked worker process
contains one or more service threads. Each concurrent http operation is
dispatched to a separate thread (which may only comprise one thread per
process). The worker service model is serially entrant. So you would need
On 7 Sep 2014, at 3:49am, Keith Medcalf wrote:
> You say "the database connection". Did you use the language imprecisely or
> are you using only one database connection? One presumes that you may have
> half-a-million pages and half-a-billion concurrent HTTP operations,
As a general principle, database transactions should be held for as short a time
as possible. You should start your transaction, then do all of the operations
immediately that need to be mutually consistent, and then end the transaction
appropriately; ideally a transaction is only open for a
On Saturday, 6 September, 2014, at 20:23, Richard Warburton
inquired:
>Brief:
>Should transactions be used for ensuring consistency between multiple
>queries? And if so, after I've finished is there a reason why I should
>not call commit?
>Background:
>I'm
On 7 Sep 2014, at 3:22am, Richard Warburton
wrote:
> Should transactions be used for ensuring consistency between multiple
> queries?
Good idea.
> And if so, after I've finished is there a reason why I should not
> call commit?
You should finish the
Hi,
Brief:
Should transactions be used for ensuring consistency between multiple
queries? And if so, after I've finished is there a reason why I should not
call commit?
Background:
I'm using SQLite for a web service. The database reference is passed to
Page objects, which handle their specific
7 matches
Mail list logo