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

2014-10-14 Thread Pontus Bergsten
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

2014-10-15 Thread Pontus Bergsten
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 <d...@sqlite.org> Ti

[sqlite] Problem with concurrent transaction and DETACH DATABASE

2012-06-20 Thread Pontus Bergsten
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

2012-06-20 Thread Pontus Bergsten
Från: Pavel Ivanov <paiva...@gmail.com> Till: Pontus Bergsten <pontus_bergs...@yahoo.se>; General Discussion of SQLite Database <sqlite-users@sqlite.org> Skickat: onsdag, 20 juni 2012 14:27 Ämne: Re: [sqlite] Problem with concurrent transaction and DETACH DATABASE Pro

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

2012-06-20 Thread Pontus Bergsten
0, 2012 at 9:27 AM, Pontus Bergsten <pontus_bergs...@yahoo.se> 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 prep

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

2012-06-20 Thread Pontus Bergsten
t")   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 <paiva...@gmail.com> Till: Pontu

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

2012-06-21 Thread Pontus Bergsten
tep/reset. However, now it works like a charm :) Pavel, thanks for your input. Pontus Från: Pavel Ivanov <paiva...@gmail.com> Till: Pontus Bergsten <pontus_bergs...@yahoo.se>; General Discussion of SQLite Database <sqlite-users@sqlite.org>

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

2012-06-21 Thread Pontus Bergsten
Aaah... I only read the documentation in sqlite3.h. Thanks for the tip. Pontus Från: Simon Slavin <slav...@bigfraud.org> Till: Pontus Bergsten <pontus_bergs...@yahoo.se>; General Discussion of SQLite Database <sqlite-users@sqlite.org> Sk