Platforms to show: All Mac Windows Linux Cross-Platform
FAQ.How to set cache size for SQLite or REALSQLDatabase?
Answer: You use the pragma cache_size command on the database.
Default cache size is 2000 pages which is not much.
You get best performance if whole database fits in memory.
At least you should try to have a cache big enough so you can do queries in memory.
You only need to call this pragma command once after you opened the database.