Tip of the day: SQLite Cache

Whenever you open a SQLite database in your application, please remember to first send this command via SQL Execute:

PRAGMA cache_size = 10000

this will increase the cache. Default is 2000 pages and with a page size of 1024 bytes that's only 2 MB of cache. You can easily set it to 10000 or 20000 pages on modern computers. This way you increase SQLite performance a lot!

This works for REALSQLDatabase, SQLDatabaseMBS and SQLConnectionMBS in Real Studio as well as with our MBS Filemaker Plugin when used with SQLite.