# Improving Instance Performance (Megatopics, Database Size and Extreme Load)

**URL:** <https://meta.discourse.org/t/improving-instance-performance-megatopics-database-size-and-extreme-load/144277>\
**Category:** Self-hosting\
**Created:** [14 maart 2020 om 01:02 UTC](https://meta.discourse.org/t/improving-instance-performance-megatopics-database-size-and-extreme-load/144277 "2020-03-14T01:02:32Z")\
**Posts on this page:** 1\
**Showing post:** 9

<div class="post-metadata">

**Author:** ![pfaffman](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/pfaffman/32/120154_2.png) [@pfaffman](https://meta.discourse.org/u/pfaffman)\
**Post date:** [19 maart 2020 om 15:47 UTC](https://meta.discourse.org/t/improving-instance-performance-megatopics-database-size-and-extreme-load/144277/9 "2020-03-19T15:47:24Z")

</div>

I’ve got a site with a handful of \>100K post mega topics. I told them that it was a mistake, but they wanted them anyway. They are complaining about performance issues. I’m hoping that I’ll soon be able to change the value back to the 10K default.

It did cause me to learn some stuff about database optimization, so that’s a bonus. 🙂

---

_[View the full topic](https://meta.discourse.org/t/improving-instance-performance-megatopics-database-size-and-extreme-load/144277)._
