want to design and ship exciting functionality. Our stack makes very heavy use
of SQLite to power some interesting Big Data use cases, and so posting here
seemed logical. Compensation is competitive - cash and equity. The job would be
in NYC.
http://dotalign.com/careers
Vince Scafaria, CEO
Our application does a lot of SQLite read/write in a background process. On
some environments this hammers the disk I/O (e.g. Task Manager -> Disk). Do you
have suggestions on how we might minimize this?
Perhaps related, one operation that seems to use a lot of the Disk I/O is when
we use
tatement aborts..." is debug
output that I see in Visual Studio. No actual error is thrown, though it is of
course disconcerting.
Thank you.
Vince Scafaria
tatement aborts..." is debug
output that I see in Visual Studio. No actual error is thrown, though it is of
course disconcerting.
Thank you.
Vince Scafaria
One possibility: Does ATTACH DATABASE count as a schema change?
From: Vince Scafaria
Sent: Monday, February 29, 2016 10:31 PM
To: 'sqlite-users at mailinglists.sqlite.org'
Subject: Database is locked (wal) - purely from read-only connections/queries
Richard, I can confirm that having
SCHEMA errors? I am not running any SQL
that I would generally consider to be altering the schema. I'm simply doing
multiple concurrent reads on read-only connections and running INSERT/UPDATE
(not CREATE/DROP) statements on the writable connection. Thank you.
Vince Scafaria
I am using System.Data.SQLite in .NET and encountering "database is locked"
with wal using multiple threads from the same process running simple select
statements with (separate) read-only connections. Please see the link below and
note the Visual Studio output window when it runs.
7 matches
Mail list logo
