DB Cache Size vs PRAGMA cache_size (currently set to -2000)

[stevezau]

Hi All,

I have a large plex db. It is about 1.5GB after running @ChuckPa 's GitHub - ChuckPa/PlexDBRepair: Database repair utility for Plex Media Server databases.

Reading this… Suggested SQLite3 DB Optimizations - #140 by jasonsansone

From what I understand the new db cache setting means you no longer need to do binary hacking. I have 128GB of memory, my database is 1.5GB so i set the db cache to 2048mb.

However, if i go to the db and look at cache_size it is set to -2000.

sqlite> PRAGMA cache_size;
-2000

I am unclear if i need to also update the cache_size on the db directly?

Thanks!

[gbooker02]

The cache_size is a per-connection property. That means anything connecting to the DB other than PMS is going to have its own value and what you see there is not related to the value that PMS uses.