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
