Regarding: "I found that win function FlushFileBuffers (used by SQLite)
slows down performances,..."
Perhaps you've already seen this message thread from 2005 below. Maybe
FILE_FLAG_WRITE_THROUGH instead of FlushFileBuffers would benefit your
particular application. (I don't know what would
> I found that win function FlushFileBuffers (used by SQLite) slows down
> performances,
> but still don't have explanation why this funcion on some machines
> works 10x slower then on others.
>
> I have used win xp sp2 on all machines where I have tested the
> behaviour.
Try using CodeAnalyst,
ines where I have tested the behaviour.
>
>
>
>
>
> From: Sherief N. Farouk <[EMAIL PROTECTED]>
> To: General Discussion of SQLite Database <sqlite-users@sqlite.org>
> Sent: Tuesday, November 4, 2008 5:53:16 PM
> Subject: Re: [sql
.
From: Sherief N. Farouk <[EMAIL PROTECTED]>
To: General Discussion of SQLite Database <sqlite-users@sqlite.org>
Sent: Tuesday, November 4, 2008 5:53:16 PM
Subject: Re: [sqlite] Slow INSERT on fast machine, fast INSERT on slow machine
> The problem is that I'm getting better per
> The problem is that I'm getting better performance on AMD machine with
> ATA disk,
> but 10 times slower on DualCore machine with SATA disk (both disks are
> at 7200 rpm)...
> I don't understand the source of this behaviour...
OS? Tried VSTS profiler, VTune or the free CodeAnalyst to look at
the source of this behaviour...
From: John Stanton <[EMAIL PROTECTED]>
To: General Discussion of SQLite Database <sqlite-users@sqlite.org>
Sent: Tuesday, November 4, 2008 4:11:30 PM
Subject: Re: [sqlite] Slow INSERT on fast machine, fast INSERT on
First, wrap your inserts into a BEGIN...COMMIT transaction. Expect the
machine with the fastest disk rotation to perform the inserts fastest.
Darko Filipovic wrote:
> Hello,
>
> I'm having following situation:
> Table:
> CREATE TABLE TEST_TABLE (
> COL1 INTEGER(20) NOT NULL,
> COL2
Hello,
I'm having following situation:
Table:
CREATE TABLE TEST_TABLE (
COL1 INTEGER(20) NOT NULL,
COL2 INTEGER(20) NOT NULL,
COL3 REAL(30,10),
COL4 REAL(30,10),
COL5 REAL(30,10),
COL6 REAL(30,10),
COL7 REAL(30,10),
COL8 REAL(30,10),
COL9 REAL(30,10),
COL10
nce:
http://www.sqlite.org/cvstrac/wiki?p=MultiThreading
Regards,
-- Tito
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: lunedì 31 gennaio 2005 10.58
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] slow "INSERT"
You should use a transaction ot
Alessandro,
Take a few minutes to read the different wiki pages. There is a lot of
info there. Answering your question:
http://www.sqlite.org/cvstrac/wiki?p=PerformanceTuning
Just scroll at the end of the page: Use transactions when updating
tables. Another reference:
g>
cc:(bcc: clive/Emultek)
Subject: [sqlite] slow "INSERT"
Hi,
I'm a new sqlite user.
For sure I'm doing something wrong with sqlite because it takes about 1 second
to perform 10 INSERT operation !
If instead I use the sqlite client and read an external file with thousands
Hi,
I'm a new sqlite user.
For sure I'm doing something wrong with sqlite because it takes about 1 second
to perform 10 INSERT operation !
If instead I use the sqlite client and read an external file with thousands of
INSERT operation the updating is
almost immediate.
The test program I'm using
12 matches
Mail list logo
