Xojo Conferences

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.
// 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.

Feedback, Comments & Corrections

The biggest plugin in space...

MBS Xojo Chart Plugins