us Bergsten ; General Discussion of SQLite
Database
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 PM, Pontus Bergsten
wrote:
When the application is executed on Windows o
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
http://sqlite.org:8080/cgi-bin/mailman/listi
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 the performance of sqlite3
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 system, the
> copying of data
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 copying works fine and the perf
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 definition
> tables + two l
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:
http://www.sqli
7 matches
Mail list logo
