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.