Re: [sqlite] Slow INSERT on fast machine, fast INSERT on slow machine

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 expl

Re: [sqlite] Slow INSERT on fast machine, fast INSERT on slow machine

> 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, s

Re: [sqlite] Slow INSERT on fast machine, fast INSERT on slow machine

hines where I have tested the behaviour. > > > > > > From: Sherief N. Farouk <[EMAIL PROTECTED]> > To: General Discussion of SQLite Database > Sent: Tuesday, November 4, 2008 5:53:16 PM > Subject: Re: [sqlite] Slow INSERT on fast machine

Re: [sqlite] Slow INSERT on fast machine, fast INSERT on slow machine

viour. From: Sherief N. Farouk <[EMAIL PROTECTED]> To: General Discussion of SQLite Database 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 performance on AMD mach

Re: [sqlite] Slow INSERT on fast machine, fast INSERT on slow machine

> 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 whe

Re: [sqlite] Slow INSERT on fast machine, fast INSERT on slow machine

understand the source of this behaviour... From: John Stanton <[EMAIL PROTECTED]> To: General Discussion of SQLite Database Sent: Tuesday, November 4, 2008 4:11:30 PM Subject: Re: [sqlite] Slow INSERT on fast machine, fast INSERT on slow machine First, w

Re: [sqlite] Slow INSERT on fast machine, fast INSERT on slow machine

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 INTEGER

[sqlite] Slow INSERT on fast machine, fast INSERT on slow machine

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 REAL(30,10)