I can attest to efficiency improvements due to at least one of the notes in SQLite Optimization FAQ. Used it at a customer site once, too long ago to remember the numbers but I recall the difference was dramatic. Sample of the commands needed:
C:\Steve>sqlite test.db
C:\Steve>call sqlite-STEVEM2 test.db
C:\Steve>"C:\App\SQLite\sqlite3.exe" test.db
SQLite version 3.3.5
Enter ".help" for instructions
sqlite> pragma default_cache_size;
2000
sqlite> pragma default_cache_size=200000;
sqlite> pragma default_cache_size;
200000
sqlite> .exit
C:\Steve>sqlite test.db
C:\Steve>call sqlite-STEVEM2 test.db
C:\Steve>"C:\App\SQLite\sqlite3.exe" test.db
SQLite version 3.3.5
Enter ".help" for instructions
sqlite> pragma default_cache_size;
200000
sqlite> .quit
C:\Steve>
|