search

pocketnetteam / pocketnet.core

Decentralized social network based on the blockchain
https://pocketnet.app
Apache License 2.0
115 stars 28 forks source link

Implementation of the SQLite cache resizing parameter #120

Open andyoknen opened 2 years ago

andyoknen commented 2 years ago

Implement a parameter to change the size of the SQLite connection cache at the job level, instead of compiling. There should be two parameters - one for the main connection and one for read-only connections. Define default values

andyoknen commented 2 years ago

@tawmaz Is there any progress on this task?

tawmaz commented 2 years ago

Pull request: https://github.com/pocketnetteam/pocketnet.core/pull/151

andyoknen commented 2 years ago

In release 0.20.18, the parameters are disabled due to problems starting a node with an existing database - additional research is needed on this https://github.com/pocketnetteam/pocketnet.core/blob/46fcd72b7810775027b0298af7321d461f88b4f1/src/pocketdb/SQLiteDatabase.cpp#L174

I was also experiencing problems with the sqlsharedcache argument https://github.com/pocketnetteam/pocketnet.core/blob/46fcd72b7810775027b0298af7321d461f88b4f1/src/pocketdb/SQLiteDatabase.cpp#L141