[sqlite] Problem with concurrent transaction and DETACH DATABASE

he code in Thread 2 (19) -(32) seems to work fine in a single threaded unit test. We're using SQLite v. 3.6.21 on Windows XP. Does anyone have any idea about the source of this problem? Have we missed something regarding SQLite and multi-threading? Regards, Pontus Bergsten ___

Re: [sqlite] Problem with concurrent transaction and DETACH DATABASE

from commit? And do you really use only INSERT INTO ... SELECT in thread 2 and no other SELECT queries? Pavel On Wed, Jun 20, 2012 at 7:42 AM, Pontus Bergsten wrote: > In our application we have two threads implementing a signal logger > functionality, see pseudo code below. > Th

Re: [sqlite] Problem with concurrent transaction and DETACH DATABASE

0, 2012 at 9:27 AM, Pontus Bergsten wrote: > Thanks for the response, > > > In fact, Thread 2 uses a series of INSERT INTO...SELECT queries to transfer > data in chunks in a loop, from "main" to "Dest". The queries are prepared > once in the beginning of th

Re: [sqlite] Problem with concurrent transaction and DETACH DATABASE

E Dest")   returns 1( SQLITE_ERROR )    release mutex    ... } as before copying data from "main" to "Dest" before entering the synchronized section is successful, but detach fails. Pontus ________ Från: Pavel Ivanov Till: Pontus Bergsten ; General Dis

Re: [sqlite] Problem with concurrent transaction and DETACH DATABASE

tep/reset. However, now it works like a charm :) Pavel, thanks for your input. Pontus Från: Pavel Ivanov Till: Pontus Bergsten ; General Discussion of SQLite Database Skickat: onsdag, 20 juni 2012 17:45 Ämne: Re: [sqlite] Problem with concurrent tr

Re: [sqlite] Problem with concurrent transaction and DETACH DATABASE

Aaah... I only read the documentation in sqlite3.h. Thanks for the tip. Pontus Från: Simon Slavin Till: Pontus Bergsten ; General Discussion of SQLite Database Skickat: torsdag, 21 juni 2012 13:46 Ämne: Re: [sqlite] Problem with concurrent transaction

[sqlite] Performance issue when copying data from one sqlite database to another

ful work for about 5% of of the total time, the rest was waiting. Is there any technique that can be used for tuning the performance of sqlite3 in this scenario? For example, writing larger chunks of data to the "Dest" database? Regards, Pontus Bergsten __

Re: [sqlite] Performance issue when copying data from one sqlite database to another

"INSERT INTO ... FROM  ... WHERE" statements. The reason for this was to display some progress to the user. Next, I will try to transfer data data in larger chunks and see it makes any difference. Any other ideas are most welcome! Regards, /Pontus   Från: Richard Hipp Till: Pont