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
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
__
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
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>
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
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
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
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
__
8 matches
Mail list logo