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.
Example
// set cache size to 20000 pages which is about 20 MB for default page size
dim db as REALSQLDatabase
db.SQLExecute "PRAGMA cache_size = 20000"

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.


The biggest plugin in space...