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 h
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 interactio
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 dat
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 the
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 the other thread blocks never to return (on a bind statement).
I WAS using the sam
9 matches
Mail list logo