Jump to content
  • 0

permanent variable vs sql


nobukadnezar

Question


  • Group:  Members
  • Topic Count:  35
  • Topics Per Day:  0.01
  • Content Count:  163
  • Reputation:   7
  • Joined:  01/07/12
  • Last Seen:  

I have question, which one better?

 

if have 300 quest npc and each of them have 20 permanent variables.

or

using database for npc quest, so each time user click on npc, it will query for correspond npc quest.

 

thank you.

Link to comment
Share on other sites

3 answers to this question

Recommended Posts


  • Group:  Forum Moderator
  • Topic Count:  93
  • Topics Per Day:  0.02
  • Content Count:  10013
  • Reputation:   2345
  • Joined:  10/28/11
  • Last Seen:  

you can read this as reference...

http://www.eathena.ws/board/index.php?s=126f1dea16ce16b4ac3cd6fc3160da3c&showtopic=181741&view=findpost&p=998360

 

for your case...definitely SQL better

Link to comment
Share on other sites


  • Group:  Developer
  • Topic Count:  10
  • Topics Per Day:  0.00
  • Content Count:  2407
  • Reputation:   613
  • Joined:  07/05/12
  • Last Seen:  

300 quest npc and each of them have 20 permanent variables

300*20=6000 pvariables

https://github.com/rathena/rathena/blob/master/src/common/mmo.h#L58

#define GLOBAL_REG_NUM 256 ///Max permanent character variables per char

...

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  35
  • Topics Per Day:  0.01
  • Content Count:  163
  • Reputation:   7
  • Joined:  01/07/12
  • Last Seen:  

 

300 quest npc and each of them have 20 permanent variables

300*20=6000 pvariables

https://github.com/rathena/rathena/blob/master/src/common/mmo.h#L58

#define GLOBAL_REG_NUM 256 ///Max permanent character variables per char

...

 

does it mean it only give max 256 permanent variables overall? or 256 per npc?

 

also is it ok to have 300 quest npc that use query?

 

thank you

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...