1. Beatrix Willius
  2. as SQLite DB Server
  3. Thursday, June 11 2020, 11:57 AM
  4.  Subscribe via email
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
Attachments (1)
Comment
There are no comments made yet.
Sergey Pashkov Accepted Answer
Hello Beatrix,

Yes, -2000 makes sense, it is 2000 KB (positive value sets the number of pages)

PRAGMA cache_size = pages;
PRAGMA cache_size = -kibibytes;

It works from the Valentina Studio.
From V4RB, do you set it and read back using the same connection?
References
  1. https://www.sqlite.org/pragma.html#pragma_cache_size
Comment
There are no comments made yet.
Beatrix Willius Accepted Answer
Hi guys,

how do I set the cache size for VSQLite?
Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories