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(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), > COL11 DATETIME NOT NULL); > CREATE INDEX XI1_TEST_TABLE_COL11 ON TEST_TABLE (COL11); > CREATE INDEX XI2_TEST_TABLE_COL2 ON TEST_TABLE (COL2); > CREATE INDEX XI3_TEST_TABLE_COL1 ON TEST_TABLE (COL1); > > I'm doing following insert (100x) out of transaction: > INSERT INTO TEST_TABLEVALUES ( 1, 527047, 2902.9326171875, 1180.5153808594, > 177.3292846680, 850.6628417969, 0.0000000000, 578.7066650391, > 2727.7397460938, 922.6400756836, '2008-10-29 13:22:06' ); > > I was doing this test on: > - DualCore 2.5GHz machine SATA2 disk and on > - AMD Athlon 1.8GHz ATA disk. > > I'm getting 10 times better performances on AMD machine, then on DualCore, > precisely, AMD machine took about 1 second to write 100 rows, and DualCore > machine took about 10 seconds. > > Can someone, please, explain to me this behaviour, or even better help me to > speed up DualCore test?! > > Thank you in advance! > Darko F. > > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
