On Wed, 9 Mar 2016 17:18:15 -0500, Philippe Riand
wrote:
> Yes, I?m using prepare(), step and finalize(). The 2 threads should
> actually have no interaction between them, but isolated.
> I mean the 2 threads should be able to do very different
> things (read data, write data?), within separated
On 9 Mar 2016, at 10:15pm, Philippe Riand wrote:
> I tries busy_timeout but that was unsuccessful.
What did you set the time to ? Try 5 minutes.
You should definitely remove all the unusual PRAGMAs apart from that one and
see if that makes the problem go away.
Simon.
Yes, I?m using prepare(), step and finalize(). The 2 threads should actually
have no interaction between them, but isolated. I mean the 2 threads should be
able to do very different things (read data, write data?), within separated
transactions.
On the OS standpoint, we are using multiple ones: Android, iOS and desktop
(Windows, OSX and Linux). So we need to figure a solution that works with all
these OSes.
when I used the WAL mode, I got a schema locked, while in DELETE mode i got
database locked.
>>>If WAL is supported, then you can
On 9 Mar 2016, at 5:00am, Philippe Riand wrote:
> 1- Is it safe to share a single connection between all these threads
> (assuming serialized mode)?
In addition to Keith's excellent reply ...
Are you using _prepare(), _step(), _finalize() ? If so then make sure you
understand the
I?m a bit lost with the multi-threaded concurrent access errors I?m getting,
and looking for an advise on the best solution.
Basically, I have a desktop/mobile app (single user) that embeds a tiny local
http server. The UI is done through an embedded browser, calling the server for
pages and
On Tuesday, 8 March, 2016 22:00 +07:00, Philippe Riand said:
> I?m a bit lost with the multi-threaded concurrent access errors I?m
> getting, and looking for an advise on the best solution.
> Basically, I have a desktop/mobile app (single user) that embeds a tiny
> local http server. The UI is
"Gene Allen"
<[EMAIL PROTECTED]> wrote in
message
news:!&[EMAIL PROTECTED]
> I'm using SQLite v. 3.5 in my multithreaded application.
>
> I have 2 threads both writing to the same database, different tables
> but same database. All is good until one of the threads goes under
> HEAVY load, then
8 matches
Mail list logo