# 'Database Cache Size (MB)' Optimal Setting for Large Library **URL:** \ **Category:** Plex Media Server\ **Tags:** server-windows\ **Created:** [September 4, 2023, 1:43pm UTC](https://forums.plex.tv/t/database-cache-size-mb-optimal-setting-for-large-library/852506 "2023-09-04T13:43:33Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![SweatRiley](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/sweatriley/32/309589_2.png) [@SweatRiley](https://forums.plex.tv/u/SweatRiley)\ **Post date:** [September 4, 2023, 1:43pm UTC](https://forums.plex.tv/t/database-cache-size-mb-optimal-setting-for-large-library/852506/1 "2023-09-04T13:43:33Z")
Hi, what is the optimal number to input in the ‘Database Cache Size (MB)’ for a large library? Mu library’s cache folder is 5.98GB and my metadata folder is 12.4GB. The default setting is 40MB. Do I need to raise this? Please explain the ‘why?’ and what the ideal value should be for me? Server Version#: 1.32.5.7349 Player Version#: \ ---
**Author:** ![tom80H](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/tom80h/32/19753_2.png) [@tom80H](https://forums.plex.tv/u/tom80H)\ **Post date:** [September 4, 2023, 2:07pm UTC](https://forums.plex.tv/t/database-cache-size-mb-optimal-setting-for-large-library/852506/2 "2023-09-04T14:07:12Z")
You might want to have a look at this thread. > [@Support Doc for Database Cache Size (MB)?](https://forums.plex.tv/t/support-doc-for-database-cache-size-mb/822583): > > With the inclusion of the server setting Database Cache Size (MB) will plex be supplying a support doc on how best to tune this for admins and their specific system ? I have my own opinions for my system however, I’d like to see what plex recommends for any given system and its resources. BTW… thanks for adding this slight_smile ---
**Author:** ![SweatRiley](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/sweatriley/32/309589_2.png) [@SweatRiley](https://forums.plex.tv/u/SweatRiley)\ **Post date:** [September 4, 2023, 2:07pm UTC](https://forums.plex.tv/t/database-cache-size-mb-optimal-setting-for-large-library/852506/3 "2023-09-04T14:07:41Z")
I read that thread but still did not find any specific answers. ---
**Author:** ![tom80H](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/tom80h/32/19753_2.png) [@tom80H](https://forums.plex.tv/u/tom80H)\ **Post date:** [September 4, 2023, 2:10pm UTC](https://forums.plex.tv/t/database-cache-size-mb-optimal-setting-for-large-library/852506/4 "2023-09-04T14:10:41Z")
The gist of the thread is: There’s no „one-size-fits-all ideal configuration“. If you run into very specific issues you can start testing to increase the cache size in small increments. There’s no need to increase the value just for the sake of increasing it. ---
**Author:** ![anon5074910](https://avatars.discourse-cdn.com/v4/letter/a/db5fbb/32.png) [@anon5074910](https://forums.plex.tv/u/anon5074910)\ **Post date:** [September 4, 2023, 2:11pm UTC](https://forums.plex.tv/t/database-cache-size-mb-optimal-setting-for-large-library/852506/5 "2023-09-04T14:11:49Z")
Your right, no one wants to answer the specific question on the cache size outside of 1) leave it alone and leave it at the default and 2) run chucks tool → [GitHub - ChuckPa/PlexDBRepair: Database repair utility for Plex Media Server databases](https://github.com/ChuckPa/PlexDBRepair) which itself will have a significant performance gain if its never been run before on your db. ---
**Author:** ![SweatRiley](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/sweatriley/32/309589_2.png) [@SweatRiley](https://forums.plex.tv/u/SweatRiley)\ **Post date:** [September 4, 2023, 2:13pm UTC](https://forums.plex.tv/t/database-cache-size-mb-optimal-setting-for-large-library/852506/6 "2023-09-04T14:13:28Z")
Ok got it, I experience no issues at home but during remote play I notice Plex transcoding and downgrading video quality even though quality is set to directplay/directstream and maximum quality output on both sides. I was curious if increasing the number would impact this and/or have other performance benefits. ---
**Author:** ![SweatRiley](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/sweatriley/32/309589_2.png) [@SweatRiley](https://forums.plex.tv/u/SweatRiley)\ **Post date:** [September 4, 2023, 2:16pm UTC](https://forums.plex.tv/t/database-cache-size-mb-optimal-setting-for-large-library/852506/7 "2023-09-04T14:16:13Z")
I have definitely never done anything like this. I use Windows 11 for my server and I do not use RAID. It is just standard playback from my internal hard drives. Will the GitHub utility still work for me? ---
**Author:** ![anon5074910](https://avatars.discourse-cdn.com/v4/letter/a/db5fbb/32.png) [@anon5074910](https://forums.plex.tv/u/anon5074910)\ **Post date:** [September 4, 2023, 2:32pm UTC](https://forums.plex.tv/t/database-cache-size-mb-optimal-setting-for-large-library/852506/8 "2023-09-04T14:32:49Z")
Yes, I believe it has a windows batch script. I’m a linux guy so windows is not my thing. But reach out on that other thread and the community folks should help with any questions. ---
**Author:** ![SweatRiley](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/sweatriley/32/309589_2.png) [@SweatRiley](https://forums.plex.tv/u/SweatRiley)\ **Post date:** [September 4, 2023, 4:12pm UTC](https://forums.plex.tv/t/database-cache-size-mb-optimal-setting-for-large-library/852506/9 "2023-09-04T16:12:32Z")
I read through the github link. I’m not comfortable running the .bat script without seeing exact steps laid out. I am sure there are some file locations that need to be updated within the script. I have ran .bat scripts before, but this one is more complex and I’m nervous about how it might affect my PMS if I do something wrong. ---
**Author:** ![anon5074910](https://avatars.discourse-cdn.com/v4/letter/a/db5fbb/32.png) [@anon5074910](https://forums.plex.tv/u/anon5074910)\ **Post date:** [September 4, 2023, 4:27pm UTC](https://forums.plex.tv/t/database-cache-size-mb-optimal-setting-for-large-library/852506/10 "2023-09-04T16:27:42Z")
If you read through the thread [Support Doc for Database Cache Size (MB)?](https://forums.plex.tv/t/support-doc-for-database-cache-size-mb/822583) that will give you all the information you need. The github link is the tool itself. Reach out to [ChuckPa](https://forums.plex.tv/u/ChuckPa) within that thread, he is always willing to help and is the owner of the tool. ---
**Author:** ![TeknoJunky](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/teknojunky/32/165055_2.png) [@TeknoJunky](https://forums.plex.tv/u/TeknoJunky)\ **Post date:** [September 4, 2023, 4:50pm UTC](https://forums.plex.tv/t/database-cache-size-mb-optimal-setting-for-large-library/852506/11 "2023-09-04T16:50:58Z")
if everything works fine locally, then it is most likely not a database problem. likewise, if the same file plays locally, but not remotely, then its not a file problem. that primarily leaves either a transcoding resource issue, or a network issue, or an unnoticed misconfiguration that causes a transcoding/network issue. or it could just be the network between your server and your client. is it just one remote client? then look at client config/network. is it all remote clients/all files? then look at server config/network probably best for you to start a new thread with all of the specific details of your network/server/client and go from there, as this thread here isn’t about troubleshooting connection/transcoding/quality problems. ---
**Author:** ![system](https://global.discourse-cdn.com/plex/original/3X/2/a/2acb9765406f63293d357b4ec509ec39aa28f2ad.png) [@system](https://forums.plex.tv/u/system)\ **Post date:** [December 3, 2023, 4:51pm UTC](https://forums.plex.tv/t/database-cache-size-mb-optimal-setting-for-large-library/852506/12 "2023-12-03T16:51:37Z")
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.