# Increase paameter value on DB for performance
**URL:** https://forums.plex.tv/t/increase-paameter-value-on-db-for-performance/899972
**Category:** Plex Media Server
**Tags:** server-mac, roku
**Created:** [December 26, 2024, 3:31pm UTC](https://forums.plex.tv/t/increase-paameter-value-on-db-for-performance/899972 "2024-12-26T15:31:53Z")
**Posts on this page:** 5
**Page:** 1
### Author:  [@IMacosiris](https://forums.plex.tv/u/IMacosiris)
#### Post date: [December 26, 2024, 3:31pm UTC](https://forums.plex.tv/t/increase-paameter-value-on-db-for-performance/899972/1 "2024-12-26T15:31:53Z")
Server Version#:1.41.3.9314-a0bfb8370
Hi guys hope you can help me
I have a PMS on a macOS with macOS Sequoia 15.1.1 with a Intel i5 and 32GB of RAM
The server works very well the plex install is over a new SSD disk and the server only run Plex, nothing else.
I have a large library arround 10.000 movies and 1000 Tv Shows also near 250Gb of Photos.
The media library when i browse is feel a bit slow (like paging ) , i was checking the RAM and CPU usage and nothing is high, the CPU and memory is quite low .
So my question is, there is a way to increase parameters on the SQL engine to take more resource on the server?
i see a post (closed) over linux server to change some parameters but i have no luck with some of them
as reference
> [@Suggested SQLite3 DB Optimizations](https://forums.plex.tv/t/suggested-sqlite3-db-optimizations/794749/16):
>
> +1 That was a long shot anyway. slight_smile
Again the server is working, no transcoding issues, only seek to increase the performance of the DB so when i browse the Media library wotk a bit faster on remote connections.
I have several clients
PS4, Roku, appleTV, phones iOS and Android, browsers, and clients located on remote cities
All the clients and dvices are in the last available OS, firmware and client version possible.
Hope you can help me
Br
---
### Author:  [@Volts](https://forums.plex.tv/u/Volts)
#### Post date: [December 27, 2024, 10:18am UTC](https://forums.plex.tv/t/increase-paameter-value-on-db-for-performance/899972/2 "2024-12-27T10:18:25Z")
Have you changed the `page_size`, either manually or (much easier) using @ChuckPA’s database script? Defaults are fine.
> **[GitHub - ChuckPa/PlexDBRepair: Database repair utility for Plex Media Server...](https://github.com/ChuckPa/PlexDBRepair)**
>
> Database repair utility for Plex Media Server databases
That’s the most meaningful performance change, IMO. His script will rebuild indexes. Other than that, 10K movies isn’t a dramatically huge number, so my first guess isn’t some fundamental database issue - is there some reason you think that might be it?
---
### Author:  [@IMacosiris](https://forums.plex.tv/u/IMacosiris)
#### Post date: [January 3, 2025, 9:15pm UTC](https://forums.plex.tv/t/increase-paameter-value-on-db-for-performance/899972/3 "2025-01-03T21:15:17Z")
Hi Volts thanks for your help i try the script but i didn’t see the option to change the parameter until you pointed i will try that and keep you posted hope is work on mac the example is for linux
Thanks for your help
have a nice year
---
### Author:  [@IMacosiris](https://forums.plex.tv/u/IMacosiris)
#### Post date: [January 6, 2025, 6:35pm UTC](https://forums.plex.tv/t/increase-paameter-value-on-db-for-performance/899972/4 "2025-01-06T18:35:30Z")
works perfect
Thanks for your help
Br
---
### Author:  [@system](https://forums.plex.tv/u/system)
#### Post date: [April 6, 2025, 6:36pm UTC](https://forums.plex.tv/t/increase-paameter-value-on-db-for-performance/899972/5 "2025-04-06T18:36:03Z")
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.