ll: Pontus Bergsten <pontus_bergs...@yahoo.se>; General Discussion of SQLite
Database <sqlite-users@sqlite.org>
Skickat: onsdag, 15 oktober 2014 0:29
Ämne: Re: [sqlite] Performance issue when copying data from one sqlite
database to another
On Tue, Oct 14, 2014 at 5:24
On Wed, 15 Oct 2014 01:26:10 +0200, Kees Nuyt
wrote:
> http://knuyt.demon.nl/sqlite.org/faq.html#q19
Oops, make that
http://www.sqlite.org/faq.html#q19
___
sqlite-users mailing list
sqlite-users@sqlite.org
On Tue, 14 Oct 2014 21:24:40 + (UTC), Pontus Bergsten
wrote:
>Hi,
>I have the following problem setup:
[...]
> INSERT INTO Dest.TheTable (field1, ..., fieldN) FROM Main.TheTable WHERE time
> BETWEEN t1 AND t2
>
> Is there any technique that can be used for tuning
On Tue, Oct 14, 2014 at 5:24 PM, Pontus Bergsten
wrote:
> When the application is executed on Windows on a desktop computer, the
> copying works fine and the performance is fairly ok, even when saving to
> USB. However, when the same code is executed on the embedded
On 14 Oct 2014, at 10:24pm, Pontus Bergsten wrote:
> INSERT INTO Dest.TheTable (field1, ..., fieldN) FROM Main.TheTable WHERE time
> BETWEEN t1 AND t2
> And here is the performance problem: When the application is executed on
> Windows on a desktop computer, the
On the embedded unit write caching disabled?
2014-10-14 23:24 GMT+02:00 Pontus Bergsten :
> Hi,
> I have the following problem setup:
> We use sqlite3 in an embedded signal logger application. The "Main"
> in-memory signal signal database consists of some minor signal
Depends on how safe/robust you want the copying to be, but if you can
simply rerun if something goes wrong, you might look into stuff like:
pragma journal_mode = MEMORY;
pragma synchronous = off;
But make sure you understand the consequences first by reading about these
commands:
7 matches
Mail list logo