Author Topic: Does Our Media Work For The People ?  (Read 340163 times)

0 Members and 4 Guests are viewing this topic.

Faith

  • Guest
Re: Does Our Media Work For The People ?
« Reply #108954 on: January 31, 2021, 11:56:08 am »
Cap the length of your threads
This is one of those things that ought to be a setting - even vBulletin is known for choking on large threads, look up rpg.net's motivational poster history. Large threads mean there is a large result set for further instructions in the query to prune from, and if a thread is too disproportionally large, even browsing the thread will result in using table scans instead of the index - a very bad situation indeed.

30k is what I use for Elliquiy, and Ben uses 25k for Red and White Kop. Keep in mind, though, that we are both running finely tuned dedicated servers with two hard disks, two cores, and 4gb of RAM. You may want to cap thread length closer to 1k posts.
Oh...yes...of course... Thanks for clearing that up.
Funny Funny x 2 View List