# Increase Resource utilization

**URL:** <https://forums.plex.tv/t/increase-resource-utilization/620955>\
**Category:** Plex Media Server\
**Tags:** server-linux, server-docker, other-dev, scanner-agent-dev\
**Created:** [August 6, 2020, 5:47am UTC](https://forums.plex.tv/t/increase-resource-utilization/620955 "2020-08-06T05:47:15Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![hokagetwo](https://avatars.discourse-cdn.com/v4/letter/h/9fc29f/32.png) [@hokagetwo](https://forums.plex.tv/u/hokagetwo)\
**Post date:** [August 6, 2020, 5:47am UTC](https://forums.plex.tv/t/increase-resource-utilization/620955/1 "2020-08-06T05:47:15Z")

</div>

Server Version#: 1.19.5.3112

Hello all, I have the opposite problem most people seem to have. When searching for answers all I could come across were people asking about too much resource utilization, but I have much more resources behind this server and would like to make use of it. Plex scanning can be kind of slow when scanning large libraries, seeming to only perform about 9 actions in parallel, but I would like to do 90 actions in parallel and have the raw resources to handle this. I was able to increase the database cache from the default to a much higher amount using the commands below, about a 10x increase in speed! While significant I’d like to increase the speed another 10x, for a total of 100x the default.

```auto
sqlite3 com.plexapp.plugins.library.db
PRAGMA default_cache_size = 6000000;

```

My server be straight sleepin. Help me make it hurt.

 ![image](https://global.discourse-cdn.com/plex/original/3X/9/4/949110995f0dcae740992d5008c3f56e7eaf3fd2.png)

---

<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:** [August 9, 2020, 4:36am UTC](https://forums.plex.tv/t/increase-resource-utilization/620955/2 "2020-08-09T04:36:57Z")

</div>

When default\_cache\_size is set to a positive value, it’s treated as the number of pages to cache. When it’s negative, it’s treated as the number of kilobytes to cache.

SQLite3’s default default\_cache\_size has been -2000 (2000\*1024 bytes, or ~2 MiB) for a while.

SQLite3’s default page\_size is 4096. So I think you’ve just set it to 6,000,000 \* 4,096 bytes = _ **~22 GB** _.

That seems like an outrageous value. 🙂

Edit: Learning more about this, it’s my understanding that this sets an upper limit. So I think this says “Up To 22 GB”, without preallocating anything.

I wonder if Plex relies on the default \_cache\_size value at all. It’s been deprecated, and Applications can specify the amount of cache for SQLite if they choose. I don’t know if Plex does or doesn’t.

How did you measure the performance improvement?

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/plex/original/3X/2/a/2acb9765406f63293d357b4ec509ec39aa28f2ad.png) [@system](https://forums.plex.tv/u/system)\
**Post date:** [November 7, 2020, 4:36am UTC](https://forums.plex.tv/t/increase-resource-utilization/620955/3 "2020-11-07T04:36:57Z")

</div>

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.