View Single Post
  #15  
Old 03-10-2012, 07:53 AM
salesman salesman is offline
Finger lickin' good.
salesman's Avatar
Join Date: Nov 2008
Location: Colorado
Posts: 1,865
salesman has much to be proud ofsalesman has much to be proud ofsalesman has much to be proud ofsalesman has much to be proud ofsalesman has much to be proud ofsalesman has much to be proud ofsalesman has much to be proud of
Quote:
Originally Posted by Cubical View Post
I'd imagine it'd be better to store it in a DB NPC as it would keep it in the memory.
You could always test it out. Create a table with several thousand rows. Create a DBNPC with the same data. Measure how long it takes to retrieve information from both of them.

Quote:
Originally Posted by Draenin View Post
Retrieving data from a database is what I'm advocating here. Storing all of that information in clientr.variables is not.
If the information is going to be accessed frequently on the clientside, you don't really have any other options. Although, I'd recommend caching anything that doesn't need to be secure in client.vars as opposed to clientr.vars. For example, the item's icon file name or a description about the item for displaying in the inventory.
__________________
Reply With Quote