Quote (njaguar @ Jul 21 2018 07:57am)
I'm going to make a change to the market at some point. I'm sure the solution won't satisfy everyone, but here is the problem and some of my current ideas at a solution:
- When items expire off the market, they sit there until you take them back onto a character.
- When a ladder resets, all items are marked as expired, and will sit there the same as above.
There is no purge happening on these, currently, so the tables have ~150k items, and 99% of them are expired.
The market is not intended to be a free storage mechanism!
With that in mind, here are a couple of solutions:
- At ladder reset, delete all items on the market that are expired from the previous season. This seems easiest, but most annoying because ladder seasons are highly variable.
- Delete items on the market that have sat expired for X amount of days. This seems most fair, because there's a known "get your gear before X" policy.
The reason this is required is I've been wanting to do a backend storage overhaul for probably a decade, but have been hamstringed by so much idle data floating around that will negatively impact any decisions on it.
He already thought of that.