Okay all, So I’m working on an item system for a gamemode. And I’m trying to figure out the best way to store all the item info. Here are my thoughts:
Have a server, and a client database, have the server send small usermessages to the client when they receive/lose an item. When they hover over it in the inventory, or click a link of it, the client will query the online DB using the itemID the server sent. (Much like WoW)
Questions about that method are:
[li]Could that cause a lot of delay on loading the data from an online database?[/li][li]Would it be a good idea if I were to ‘cache’ the items’ data in a local table?[/li][/ul]
I’m also wondering, if it isn’t a good idea to hold it all online, is there a way to have the item Database local? I’m not sure that I want to use SQLite, because I’d need to somehow update the database when I add/remove/change stuff. (Which is why I’m thinking of keeping it online)
Hope that made sense, just let me know if you need more info. Thanks in advanced all!