I’m happy to mention that the “Top Posts” section of the site is officially back in action, for the longest time it was down and showing a broken page, if only because I had every intent of fixing it. You see, the way I originally wrote that page made it do about 30 different heavy queries on the site’s database nearly every time anyone loaded it. 10 people hit it? 400 queries! Some of those queries would take minutes to complete and would slog down the rest of the server whilst doing so.
That is no more! Now I have tikibot doing the queries twice a day, saving the values to a stored value, then that value is cached along side the page and if you or 200 other people hit it all at the same time, the impact on the rest of the site is minimal at worst.
As is the usually though, while working on this I found like 5 other things that I want to fix, but this was a big one and I wanted to celebrate the win!
Also for those of you with Spaces of your own, I believe you can turn on the stats plugin and use the listed shortcodes to display the content from your own Space.
I was wrong about that, when the plugin is activated on a subspace it just fails to do anything of interest.
I need to fix that.
turns out there’s a dependency that I built in to the new top stuff that I need to figure out. hmm.