# Database Cache Size Behavior Question

**URL:** <https://forums.plex.tv/t/database-cache-size-behavior-question/822657>\
**Category:** Plex Media Server\
**Tags:** server-freebsd\
**Created:** [December 13, 2022, 11:23pm UTC](https://forums.plex.tv/t/database-cache-size-behavior-question/822657 "2022-12-13T23:23:17Z")\
**Posts on this page:** 1\
**Showing post:** 1

<div class="post-metadata">

**Author:** ![Volts](https://avatars.discourse-cdn.com/v4/letter/v/a5b964/32.png) [@Volts](https://forums.plex.tv/u/Volts)\
**Post date:** [December 13, 2022, 11:23pm UTC](https://forums.plex.tv/t/database-cache-size-behavior-question/822657/1 "2022-12-13T23:23:18Z")

</div>

[Plex Media Server 1.30.1.6483](https://forums.plex.tv/t/plex-media-server/30447/546) has added **DatabaseCacheSize** , a lovely holiday treat:

> [@](#):
>
> (Preferences) Added an advanced preference for DB cache size.

Can Plex folks explain the internal behavior of this setting?

Previously Plex’s SQLite `cache_size` was 2000 _pages_, and Plex’s model database `page_size` is 1024 _bytes_. The end result was a SQLite cache of about **2MB**.

This new setting defaults to **40MB** , a significant increase. Yay!

Internally, is Plex setting this in _megabytes_ (negative SQLite `PRAGMA cache_size` value) or is it still using a multiplier based on the `page_size`?

I ask because I’ve converted my databases to use a larger `page_size`.

Either way, I would encourage Plex to adjust the `page_size` of the template DB file as well. It makes a huge performance difference. The SQLite default was raised from **1024** to **4096** a long time ago. I think Plex’s template file was simply created a very long time ago.

Thanks!

---

_[View the full topic](https://forums.plex.tv/t/database-cache-size-behavior-question/822657)._