And FYI Big Bitter Bob, Optimus trousers lives in another part of the cloud and stores his shit in MongoDB. He has no performance issues at all.
Once every 5 minutes papster unzips my trousers and sucks the latest stuff out of me.
papster’s forum stuff uses MS SQL Server and whoever wrote it needs to be shot.
Relational good.
NoSQL gooder.
Originally posted by @saintbletch
And FYI Big Bitter Bob, Optimus trousers lives in another part of the cloud and stores his shit in MongoDB. He has no performance issues at all.
Once every 5 minutes papster unzips my trousers and sucks the latest stuff out of me.
papster’s forum stuff uses MS SQL Server and whoever wrote it needs to be shot.
The SQL server engine or the code that pulls from the database or the database design itself?
Originally posted by saintbletch
Relational good.
NoSQL gooder.
Courses for horses! Swings and Roundabouts! 6 of one, half a dozen of the other!
The code that pulls from the database, bobster.
As papster described above, to display the home page (latest posts), the code grabs the latest n threads and then grabs all of the posts for all of those threads.
This is done just to display the list of threads where the posts inside the thread are not even visible.
This happens every time someone refreshes the home page. Add Optimus trousers’ mammoth ~300 page thread into that and the server is thrashing on every F5.
The reason seems to be down to a desire show summary stats next to the thread that come from the posts.
It’s either very poor design, or as papster suggested, we’re using the forum in a way that was not intended/envisaged.
Re: horses for courses…Yep. I was just yanking your tail.
I think we’re alright on site performance now. Back up to 20 topics on Latest Topics. Still flying like shit off a shovel. Optimus Trousers has been reactivated. Bletch, can we close this bastard?
Not sure papster.
I think it might be a good thread to keep pulling back to the top if anyone has concerns about site performance, and wants to answer the “Is it just me?” question.
It’s usually slow for me…But then again, I live in Ohio. Slow is the norm.
Can’t get the “latest by…” to work.
We retired that, but the site should remember which page you’re on. It isn’t gone forever, just was causing issues. We’ll get onto that this week.
I keep beating away, but I just can’t get a woody. Maybe the site needs a tesosterone injection? Maybe some pics of booblies. Hey! I’m just trying to be helpful!!
Night and day difference in performance for me this morning papster.
Good job, mate!
If I may borrow a saying “like shit off of a hot shovel…”
Pap in “can do own job” shocker 
Cheers, bletch, although the reward is not stressing about it. It has been bugging me for weeks, could have put the kibosh on any serious growth.
I am fucking glad it’s sorted.
My 'latest by" linky thingy doesn’t work. It’s greyed out. I blame you.
Again Papster, the site is fantastic this morning, makes my work day so much better when I don’t have to wait ages for pages to load…
I have been noticing an issue with thread load times. They seem to have been getting progressively worse for me. In my capacity as admin, I noticed that I was getting great performance. What’s the diff, yo?
Turns out that there was a check on every single post determining if someone has got enough votes to be able to vote themselves. We don’t really use the feature, so it’s completely redundant. I have turned the check off, and I’m getting great performance on loading again.
Good news for any HPB (high point bastards) in similar straits.
I think this deserves a thread of its own.
Originally posted by @Fatso
I think this deserves a thread of its own.
I’m very pleased it is sorted.
Anyone noticing any slowness at the moment?
YES 