> We Have Implemented A Post Cache To Improve Performance. Please Report Any Issues.

I have an issue!

Tom is fun, but RHC and his acolyte AusCarFancier are annoying.

We had a small problem where only 16MB of posts could be cached due to a default MariaDB setting. That setting has been increased and we should now see this working more effectively.

Ron_Santo_Redux wrote:

Issue 1: You suck cock

Fuq off, Earl.

Okay I have validated that the configuration change has fixed the issue,

Update: cache seems to be working well. Haven't noticed any issues and nobody has reported any. At any given time there are about 1500 posts cached totally about 130MB. Cache hit ratio is north of 98%.

wrote:

Why do you need a post cache? Are all posts loaded separately somehow?

Every post has to be processed every single time it is displayed. For example if you have some bold text this will be stored in the DB not as HTML, but as BBCode like this:

[b]bold text[/b]

Then each time the post is displayed it gets converted to HTML.

So there ends up being a lot of repeated Regex processing on each and every post each and every time it is displayed.

So, now we process them once and store the processed result in the cache.

If an edit happens we invalidate the cache for the edited post. We also have an "age out" process for posts in the cache to accommodate processing rule changes and to keep the cache a reasonable size.

The cache is kept in a MariaDB MEMORY Engine table. It's not as fast as keeping it in Redis or memcache, but makes the implementation a lot easier.

wrote:

Did you do any profiling?

I'd guess regex would use less resources than the extra cache lookups.

There isn't an extra lookup. It's part of the same query and then a coalesce for the first non-null between messageParsed and message.

And, yes, it is definitely faster.

Go read an old thread that won't be cached. Look at the page response time in the footer. Then refresh the thread, it will come from the cache, and it will be 30-40% faster.

wrote:

There's no page response time in the footer.

Maybe it only shows up for mods.

Let me look.

<div class="block">
    <div class="box">
        <div class="inbox">
            Build: 22.9.28.1214 [camp-idiot-build-master]
        </div>
    </div>
</div>