I think you may use FTS3 extension. This is very fast for big tables too. I did test about to 500 millions rows with UUIDs in FTS3 table and results are fine. See as example test here: http://book.mobigroup.ru/dir?name=web_project_DBMS/distributed_schema Some result logs you can find in files perftest_log_*.
-- 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
