GeoMapX

Hardware laptop with Intel(R) Core(TM)2 Duo CPU T5470 1.60GHz (working as 800MHz CPU for low heating) 1 GB RAM HDD Western Digital Scorpio Black 2.5" 7200 rpm 16Mb (FS ext3) OS Debian (lenny+testing+sid). SQLite build My debian package has these options to compile SQLite 3.6.20: DEB_OPT_FLAG := -O2 -fno-strict-aliasing \ -DSQLITE_CORE=1 \ -DSQLITE_ENABLE_COLUMN_METADATA \ -DSQLITE_ENABLE_STAT2 \ -DSQLITE_DEFAULT_RECURSIVE_TRIGGERS=1 \ -DSQLITE_ENABLE_COMPRESS \ -DSQLITE_ENABLE_FTS3 \ -DSQLITE_ENABLE_INET \ -DSQLITE_ENABLE_MD5 \ -DSQLITE_ENABLE_RTREE \ -DSQLITE_ENABLE_TABLEFUNC \ -DSQLITE_ENABLE_VIRTUALTEXT \ -DSQLITE_ENABLE_ICU \ -DSQLITE_ENABLE_UUID \ -DSQLITE_ENABLE_VERSIONING \ -DSQLITE_SOUNDEX \ -DSQLITE_TEMP_STORE=3 \ -DSQLITE_DEFAULT_PAGE_SIZE=4096 \ -DSQLITE_DEFAULT_CACHE_SIZE=128000 \ -DSQLITE_DEFAULT_TEMP_CACHE_SIZE=8000 \ -DSQLITE_DEFAULT_FILE_FORMAT=4 LDFLAGS=-luuid -lz -ldl `icu-config --ldflags` You can get binary and ...

.schema CREATE TABLE role ( id INTEGER PRIMARY KEY AUTOINCREMENT, uid BLOB ); CREATE INDEX role_uid_idx on role(uid); Method 10 iterations of the 500 000 inserts: insert into role (uid) values (uid) uid=randomblob(1) $ ./test.tcl 1 7 seconds per iteration 2 7 seconds per iteration 3 7 seconds per iteration 4 7 seconds per iteration 5 7 seconds per iteration 6 7 seconds per iteration 7 7 seconds per iteration 8 7 seconds per iteration 9 7 seconds per iteration 10 7 seconds per iteration uid=randomblob(8) $ ./test.tcl 1 7 seconds per iteration 2 8 seconds per iteration 3 9 seconds per iteration 4 10 seconds per iteration 5 11 seconds per iteration 6 12 seconds per iteration 7 13 seconds per iteration 8 13 seconds per iteration 9 14 seconds per iteration 10 15 seconds per iteration uid=randomblob(16) $ ./test.tcl 1 7 seconds per iteration 2 10 seconds per iteration 3 12 seconds per iteration 4 14 seconds per iteration 5 18 seconds per iteration 6 44 seconds per iteration 7 ...