Hello, I have 3 million rows in a read only sqlite3 database (select only). I am looking for the best possible lookup performance. Below is what has been done so far, what else can be done to improve performance of select for single threaded access via C++ API on Linux 64 bit machin? 1. Load entire database/index loaded into memory using backup api. 2. Index all columns that may be in the where clause 3. Build, prepare and cache in place statements
Thanks for you help in advance Aj -- View this message in context: http://old.nabble.com/How-to-improve-sqlite3-performance-tp32442287p32442287.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
