Toggle Submenu
  1. Forums
  2. Recent
  3. Kategorien
  4. Tags
  5. Benutzer
Antwort hinzufügen Antworten ansehen (2)

Gelöst Setting cache size for VSQLite database

  1. Beatrix Willius
    Beatrix Willius
  2. as SQLite DB Server
  3. Donnerstag, Juni 11 2020, 11:57 AM
  4.  Abonnieren via E-Mail
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
Anhänge
Bildschirmfoto 2020-06-11 um 13.54.42.png Bildschirmfoto 2020-06-11 um 13.54.42.png
Kommentar
There are no comments made yet.
Antworten (2)
Beatrix Willius
Beatrix Willius Akzeptierte Antwort
Hi guys,

how do I set the cache size for VSQLite?
Kommentar
There are no comments made yet.
  1. vor über einem Monat
  2. as SQLite DB Server
  3. Permalink zu dieser Antwort
Sergey Pashkov
Sergey Pashkov Akzeptierte Antwort
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?
Referenzen
  1. https://www.sqlite.org/pragma.html#pragma_cache_size
Kommentar
There are no comments made yet.
  1. vor über einem Monat
  2. as SQLite DB Server
  3. Permalink zu dieser Antwort
  • Seite :
  • 1


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