« LCMS 2.4 | Home | MBS Real Studio Plugi… »

Tip of the day: SQLite Cache

17 09 12 - 10:02 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.
No comments

  
Remember personal info?

Emoticons / Textile

Comment moderation is enabled on this site. This means that your comment will not be visible on this site until it has been approved by an editor.
Notify:
Hide email:

Small print: All html tags except <b> and <i> will be removed from your comment. You can make links by just typing the url or mail-address.