by Keats » Mon Apr 24, 2006 4:03 pm
Yeah, the only problem I could see with that would be the large volume of dead accounts.
I'm not too sure about what you meant by holes in the database, but would they pose a problem if you were to do dumps of accounts that had been inactive for x number of days? x being a large enough number to allow character re-activation if something happens clientside and that people wouldn't have their accounts deleted before they could reactivate them but small enough that server space wouldn't be at a premium.
Maybe also those characters and their names/equipment could be converted to NPC's when they get deactivated. Perhaps travelling merchants that sell whatever equipment that they had on them when their account deactivated? Then, when the dump happens, the merchant "moves on," in other words gets deleted off the server. Assuming you're even using NPC's haha