How do I set the cache size for a VSQLite database? Doing a pragma cache_size works for a local SQLite database. But on the server the value isn't changed:
Dim theSQL As String = "CREATE VIRTUAL TABLE if not exists bodyindex USING fts4(tokenize=unicode61,content='', messagebody);"
remote_db.SQLExecute(theSQL)
remote_db.SQLExecute("PRAGMA cache_size = 50000" // 50 MB
Does a cache size of -2000 really make sense? See screenshot.
Regards
Beatrix Willius