So for those who don't know, WoW has a system called the Wardrobe, which basically keeps track of every equippable items you've ever owned. So for example, if you get some pants from a dungeon, your Wardrobe makes a note that you've collected those pants. And then even after you throw away the pants, and you can always glamour those pants onto your outfit. As someone who likes collecting and is always hurting for glamour storage, I'd love to see a system like this come to FF14.
But I've also always assumed such a system would be expensive to maintain. So many items, that's a lot of data to store! But then I thought about the fact that WoW somehow does that...so how expensive is it really? I decided to try to find out.
First, a warning: I'm a programmer, but data storage is not my specialty. So it's possible that there may be aspects of data storage that I'm overlooking, and if that's the case, I hope someone will bring them up! Other than that, I've done my best to collect and calculate information in good faith out of genuine curiosity, so let's proceed!
First, I decided to do a bit of digging to see if I could find any interesting ways to compress large amounts of boolean data (since having or not having any given item can be represented by either a 1 or a 0), but I wasn't able to immediately find anything beyond the basic recommendation of storing 1 item per bit. So I'm guessing there's a more efficient (and thus less costly) way to store data way, but for now let's just use this basic method.
According to the Lodestone, at present there are 5,176 "arms" and 12,041 "armors" in the game, for a total of 17,217 equippable items. Let's estimate that ARR, HW, StB, ShB, and EW are each responsible for 1/5 of that number, meaning that every expansion adds roughly 3,444 new equippable items to the game. So every expansion requires 3,444 bits per character, or 431 bytes.
But we'd need to plan for not just what we currently have, but for the future. FF14 has been going for 10 years, and they want to go for 10 more years, so let's add in Dawntrail for a total of 6 expansions, then double that number and assume that accounts for the next decade and some change. So 12 expansions at 431 bytes each means that every character requires 5,172 bytes of data for this Wardrobe feature alone.
There are lots of ways to store data, but AWS is a pretty common and competitively priced way, so let's use it to get an estimate of what storage rates will be. The most basic kind of data storage on AWS is S3 Standard, which is described as "General purpose storage for any type of data, typically used for frequently accessed data"; that sounds fine for our needs. Every month, this service charges $0.022 per GB. There are 1,000,000,000 bytes in a GB, so we can store Wardrobe data for 193,348 characters for just over 2 cents per month.
I don't have enough knowledge to know how the character count will grow over time, so I won't try to estimate that. But just to try to get a tangible feel for how that rate translates into real-world costs, let's see how much that pricing would cost for all of today's players. At present, there are just under 30 million characters in FF14 according to https://ffxivcensus.com. So here's our math:
Number of characters * Storage required per character * Storage cost rate = cost
Number of characters = 30,000,000 characters
Storage required per character = 5,172 bytes per character
Storage cost rate = 0.022 dollars per month per 1,000,000,000 bytes
30,000,000 characters * 5,172 bytes * 0.022 dollars per month / 1,000,000,000 bytes = 3.41352 dollars per month
I'll be honest, I'm surprised by how little that is. I'd gladly foot that bill myself! And I would guess that if anything, the costs above are more inflated than they need to be; there are likely ways to reduce the storage per character, and there are likely ways to reduce the costs of storage by choosing more appropriate service plans or by using your own infrastructure.
I am genuinely curious if there are other costs associated with storage that would meaningfully inflate this number...because if there aren't, then I feel like I've been mistaken considering the cost of storage to be an impediment to a system like this. There are naturally other costs — such as the costs of actually developing the Wardrobe feature and its interface — so it's not like this feature would be free.
Anyway, if you've got experience with data storage, etc, I'd be curious to hear your perspective on whether I'm missing anything here; sometimes you don't even know what you don't know until someone else points it out. Thanks!