See tests for 100 millions records in single table: http://book.mobigroup.ru/dir?name=web_project_DBMS/distributed_schema
And see http://geomapx.blogspot.com/2009/11/postgresql-81-vs-sqlite-3620-in-real.html http://geomapx.blogspot.com/2009/09/sqlite-3617-mobigroup2.html Old versions of SQLite had degradation of indexing speed on big tables http://geomapx.blogspot.com/2009/11/degradation-of-indexing-speed.html Use WAL mode in SQLite from version 3.7.0 or/and SSD instead of HDD. 3.7.1 has SQLITE_FCNTL_CHUNK_SIZE option and may resolve this problem but I don't test it yet. -- Best regards, Alexey Pechnikov. http://pechnikov.tel/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
