Suggested SQLite3 DB Optimizations

In a new plex installation I see 40M inside the interface but if I access the database it appears at -2000.
I have tried making the changes from DB Browser for SQLite and with Plex SQLite and whatever I do it always gives me a value of -2000, also if I change it in the interface of the latest beta and I always put a high value in PRAGMA Cache Size is -2000 is that correct?

The cache is established per connection. When you make a query, thats a separate independent connection. The plex binary is establishing its own connection and creating it using the cache defined in that new option. There isn’t any way to verify the cache size independently.

1 Like