No, the performance stays the same. I have also tried using a big cache_size, but that didn't change anything, too.
Yes, I can share the database - it is currently uploading, I will mail the link tomorrow. Imanuel Am 17.10.2012 22:08, schrieb Dan Kennedy: > On 10/18/2012 01:32 AM, Imanuel wrote: >> Hello >> >> I tested this on an SSD with a database with one single table with >> 5,553,534 entries: >> CREATE TABLE Namen(id INTEGER PRIMARY KEY, geonameid INTEGER, lang TEXT, >> name TEXT, pref INTEGER DEFAULT 0, short INTEGER DEFAULT 0, coll INTEGER >> DEFAULT 0, historic INTEGER DEFAULT 0, sort INTEGER DEFAULT 7) >> >> When running this command: >> CREATE INDEX idx_namen_name ON Namen(name) >> >> Version 3.6.22 (from here: http://indasoftware.com/sqlite/) takes 36 >> seconds, while 3.7.14.1 (as DLL, too) takes 279 seconds. >> Indexing the column "geonameid" makes 24 vs. 312 seconds. >> Neither of the both columns are presorted. > > If you set "PRAGMA temp_store = memory" in 3.7.14.1 is the > performance the same as in 3.6.22? > > Are you able to share the database? > > _______________________________________________ > 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
