View Single Post
  #19  
Old 03-10-2012, 03:04 PM
Cubical Cubical is offline
Banned
Join Date: Feb 2007
Posts: 1,348
Cubical has a brilliant futureCubical has a brilliant futureCubical has a brilliant futureCubical has a brilliant futureCubical has a brilliant futureCubical has a brilliant futureCubical has a brilliant future
Quote:
Originally Posted by Draenin View Post
Sure you do.

Information like what you just listed ("the item's icon file name or a description about the item for displaying in the inventory") can be stored more conveniently in database tables as well, and you can read from those tables just as easily as you can read them from player accounts.

Variables which are subject to change and specifically relevant to player accounts should be kept on players, and everything else should be stored in a database.
Why send 100's of unneeded server request when you can just make 1 and store it?

Also is the general consensus that I should kick the ItemCache in the DBNPC to the curb and solely rely on querying the SQL database?
Reply With Quote