I've just pushed some sites that should speed us up during Morostide, as well as alleviate some of the 504/502 errors.

Warm Up Time One of the hardest things the site has to do is "warm up" when you come on the site for the first time in ~30 minutes. Almost none of your information is in cache anymore, so it has to re-query the database for a lot of information. This has caused some of the 502/504 errors, as accounts have gotten larger and larger and more of that information needs to be queried.

I've gone through a lot of these queries that happen when you log in or view your first page, and made two possible changes.

1. Extended the amount of time cached. If these are queries that are removed when "stale", it doesn't matter if they stay in cache for days.
2. Created a "warmer" that takes the users who've been online in the past week and keeps their data warm automatically, by using a queue and filtering through users slowly.

is an entirely new solution and something just pushed for the first time - so it might not work perfectly. I'm monitoring it as it's been used over the past few hours and making tweaks where needed. If it's successful, we can offload a lot of our other heavy processing to a queue-based system like this.

What do you mean with "larger accounts" and is there any of that information that can be reduced or compressed? :)

Thanks for the update and explanation!

My guess is it's all of the stuff attached to our accounts (pets, items, collections, wardrobe). More people with a ton of stuff, so "larger accounts" in a sense.

Thanks for letting us know! For what it's worth I've only had a couple errors all day and it seemed to coincide with slowness on other sites, so it may have been my internet.

Sound like a novel solution. has hope

Thanks for the updates. Those sound like great changes that should hopefully make the site a bit less laggy in the future. Are these changes permanent or just during the events/holidays when more users are online?

nice (: I hope this helps with the errors

P.S. YAS! You're already wearing the Lil Pound Cake make :D

Thank you for the update, I appreciate it. I've only had one error today (this morning) which is a huge improvement from the last month or so of having them multiple times a day. Thanks.

I guess I'm going to have to go through my account and see what I can do, I still haven't done away with my legacy shops so there's something I could start with.

Thank you. I haven't had any errors since I got on in the last 4 hours, so that's a start :)

ME, TOO <3 I hope so bad it'll be reasonable in the shops in a while xD

And glad to see that the changes will last for the whole year if it succeeds, not only during holidays/events.

Delete accounts over a decade old then, who cares about these old crumpetmunchers and leave the site room to all of us youngsters

SHIT SHIT SHIT NO ABORT NEVERMIND I NEVER SAID THAT

Seriously, are there mid-term or long-term plans to go and cap most of these things?

I know shops now have a hard cap, and pets have always been soft-capped, but about currencies and wardrobe, namely.

No errors here either :D

Thanks for the update

Thank you for the update!

Don't cap my wardrobe plz

Not sure how you could cap the currencies unless there was a push to consolidate some of the different types of currencies. :/

My guess is users who log in at least once a week make up a large chunk of the largest account holders. This is an interesting way to help with the errors, and it does seem to be working so far. Here's to hoping it succeeds! ^^

Yeah, I guess we could use a wardrobe limit, since it seems to me that's a huge part of the data. The limit could be 15k items (because of the achievement), and let the vault unlimited. It's unlikely that anyone would use 20k clothes in a whole Subetan life, and even users that like to hoard could save the items in the vault.