Tackling 504s: inventory → vault transfer for accounts that have not logged in within six months

High End Computer Tower
Elwood Promotional T-shirt Cannon
Vault Jumpsuit
The site has handled the Keelhauliday rush well, and we're so happy to see you all!

One of the big draws this time of year is the Ocean Depths vending machine, since its rarity cap is different and it gives out items from Freyalise as part of its pool while the shop is open. (Something to keep in mind if you have those stockpiled wizard tokens. ^_~ )

But when you go to a page like the vending machine where it's modifying your inventory, it counts all of the items in your inventory to check against inventory limit. Which it does by looking at ALL inventory items in all accounts, figuring out which ones belong to you, and creating a count of that. If you add/remove any items, that cached token is removed, and it does the query again. It's intensive even during normal site traffic, but works overtime during holidays. As just mentioned Subeta's coding does has a caching system to manage the queries, but the more people online the faster the cache expires and the 504s start creeping in.

One of the ways we can reduce this load is by managing items in the inventories of people who haven't logged on for a while; their inventory items still get counted and it's a constant bottleneck we're going to keep running into especially during busier times of the year. So starting soon, if you have not logged on in six months, items in your inventory will be automatically moved to your vault.

Keith is going to add a message to the inventory page that will show up for anyone whose items got moved, but we also wanted to get the word out to people otherwise and have this in Announcements for future reference.

Thank you for reading! May the Omen Islands waters be warm for you (or cool, depending on your preferences) and don't forget to put ideas you really want to see for upcoming festivities in the Suggestions thread!
User Avatar: 605589

Posted by Galaxia

Comment
Comments are disabled for this post!