[cbk1994]

On Era Dev we're using files for storing item data (items/weapons/guns/ak47.txt, for example), and then using SQL to store individual player data, e.g. the items the player has and the quantity of the item they have. If you index it properly, it's pretty fast.

It seems to be working quite well, though we hope to find out just how well with the iPhone server.

EDIT: I should mention that we're caching the items into a DB NPC to prevent tons of file I/O and slowdowns.