Abel to Yzerman

Abel to Yzerman

Update On KK 2.0

10/06/2022 at 2:53pm EDT

We are addressing the slowness of KK 2.0. It will be right soon.

From our developer,

As we talked about pre-launch, your new site has some performance issues due to the sheer volume (100k+) of entries, which is stretching the limits of both Craft and the database itself. Every time we pull a listing page that huge number (or the 80k+ in KKH alone) makes the queries drag. It's one of the issues you had in the old EE site as well (although ancient code was a bigger one) because of that huge size.

Our hope was that caching would provide enough of a cushion to the site to make performance stable, but after pushing to production today it became clear pretty quickly that we were maxing out available resources. It's gotten a bit better as the cache has filled out and fewer uncached pages are being hit, but not good enough.

One solution, and the one we were using with the old site, is to throw more power at the problem. That gets expensive though - the host recommended moving to their Pro plan (+$50/month) or adding a dedicated database instance (+$125/month), or maybe both, to add more power to the server. I don't want to run up your monthly costs though and the web server load aside from database access is actually quite low.

We also looked into static caching, where pages are turned into flat html by the cache tool and then represent almost no load on the server, but that has 2 problems - it can't easily be used on listing page, and we can't use it on individual pages because of comments.

TeamDub

Looking good, Paul!

Good to see my humble A2Y 

banner still up. 🍻

Hope you're well!

LGRW

PaulTeamDub

We are getting there TD and the banner never comes down except for a yearly cleaning.And I am feeling good, thanks.

OTC

Here's hoping this works. And if it does, I might as well get greedy and hope that the Wings win tonight.

Create an Account

In order to leave a comment, please create an account.

About Abel to Yzerman

Welcome to Abel to Yzerman, a Red Wing blog since 1977. No other site on the internet has better-researched, fact-laden and better prepared discussions than A2Y. Re-phrase: we do little research, find facts and stats highly overrated and claim little to no preparation. There are 19 readers of A2Y. No more, no less. All of them, except maybe one, are juvenile in nature. Reminding them of that in the comment section will only encourage them to prove that.

Most Recent Posts

Most Recent Comments

Comment by KaszyckiandhisKrew in Kukla's Korner Hockey from the entry One Last Game For Jeff Carter - 7 minutes ago
Comment by Paul in Kukla's Korner Hockey from the entry BOG Approves The Establishment Of A Franchise In Utah - 47 minutes ago
Comment by NateA in Abel to Yzerman from the entry Patrick Kane On His Future - 1 hour ago
Comment by Bill_H in Abel to Yzerman from the entry Wings Are Conducting Exit Interviews Today And Tomorrow - 2 hours ago
Comment by Paul in Abel to Yzerman from the entry Patrick Kane On His Future - 2 hours ago