at mailinglists.sqlite.org] On Behalf Of Harmen
> de Jong - CoachR Group B.V.
> Sent: donderdag 18 juni 2015 15:02
> To: General Discussion of SQLite Database
> Subject: Re: [sqlite] SQLite PENDING lock before SHARED lock with WAL enabled
>
> Thanks for your feedback. We
On 23 Jun 2015, at 9:49am, Harmen de Jong - CoachR Group B.V. wrote:
> Is there anyone who can confirm that the first read transaction with WAL
> enabled locks the database because it triggers the SchemaLoaded?
The sqlite3_open() commands do not actually open the file. They don't even
make
-users-bounces at mailinglists.sqlite.org
[mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Harmen de
Jong - CoachR Group B.V.
Sent: donderdag 18 juni 2015 15:02
To: General Discussion of SQLite Database
Subject: Re: [sqlite] SQLite PENDING lock before SHARED lock with WAL enabled
at mailinglists.sqlite.org
[mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Richard Hipp
Sent: donderdag 18 juni 2015 13:00
To: General Discussion of SQLite Database
Subject: Re: [sqlite] SQLite PENDING lock before SHARED lock with WAL enabled
On 6/18/15, Harmen de Jong - CoachR Group B.V. wrote
A SELECT query obtains a SHARED lock on the database file. Doing so, there can
be many simultaneous readers according to the documentation at
https://www.sqlite.org/lockingv3.html. However, before the SHARED lock is
obtained in winLock(sqlite3_file *id, int locktype), a temporary PENDING lock
On 6/18/15, Harmen de Jong - CoachR Group B.V. wrote:
> A SELECT query obtains a SHARED lock on the database file. Doing so, there
> can be many simultaneous readers according to the documentation at
> https://www.sqlite.org/lockingv3.html. However, before the SHARED lock is
> obtained in
6 matches
Mail list logo
