Results -9 to 0 of 423

Threaded View

  1. #11
    Player
    Fendred's Avatar
    Join Date
    Jun 2011
    Posts
    956
    Character
    Valentyne Laska
    World
    Balmung
    Main Class
    Dancer Lv 100
    Whatever reason they have for not expanding player inventory, it does NOT involve having too little storage. The only reason they'd have storage problems is if they did something inefficient like store character IDs as character strings and not thirty-two bit integers with a 2-3 character length identifier. They should already have an inventory table as a result of the relationship between players and items, and even if they were forced to put a new table into the database schema for the purpose of glamour items they'd need under a terabyte of additional space across all data centers because only a small fraction of the in-game items can be applied as glamour.

    Lets say worse comes to worse and they need a new table. The table contains 4 attributes/columns which are the primary key attributes of both the item table and player table. The keys of each consist of a three character long string and a 32-bit integer. For the sake of argument, lets say there are 300 possible items that can be used as glamour, so there are at most 300 possible entries in the table per given players. Let's also assume there are four million accounts. They'd need at most 16.8 gigabytes of additional space distributed proportionally across all their data centers. We live in an era where one terabyte is the new standard for personal computers. For a major corporate datacenter, 16.8 gigabytes is laughably small.
    (4)
    Last edited by Fendred; 06-18-2015 at 10:35 PM.

Tags for this Thread