Archived

This topic is now archived and is closed to further replies.

Client Info Organization

This topic is 5624 days old which is more than the 365 day threshold we allow for new replies. Please post a new topic.

If you intended to correct an error in the post then please contact us.

Recommended Posts

I have noticed that many mmorpgs say they use a database for client information. what exactly do they mean by this? The reason i ask is because I heard of MySQL and i dont know why anyone would need a lib just for a database, so maybe it is not what i am thinking.

Share this post


Link to post
Share on other sites
I don''t quite understand what you mean? Most client server apps, indluding but not always MMP games, use a database on the backend to store all the information. That is what you were reading about.

They use databases like MS SQL, or Oracle, or MySQL, or PosgresSQL. Having a dedicated database server has unlimited advanatages over storing the information on disk. Ask Verant about the problems they''ve had with storing character information on the hard drives of the servers.

Stephen Manchester
Senior Technical Lead
Virtual Media Vision, Inc.
stephen@virtualmediavision.com
(310) 930-7349

Share this post


Link to post
Share on other sites
Well I don''t think he''s gonna make an everquest like (talking about the size).

For amateur MMORPG''s (like mine), with no more than a few hundreds players, you can do the storage on your hard-drive with not any problems.

Share this post


Link to post
Share on other sites
Why would you want to store it on disk though? Database management systems do much more of a effective and more efficient job storing data then you can, and with systems like MySQL being free now-a-days why would you want to store on the HDD?

Share this post


Link to post
Share on other sites
What? you guys don''t just buy gigs of RAM and keep all the characters cached in memory? j/k
I remember hearing something about hot HDD platters shattering on a cold flooring tile...

Actually, go with a commercial RDBMS-type of database, but remember that database operations are noticeably time consuming. You will need a good cache mechanism, and will want lots of RAM server-side.

Of course, MUDs typically store data to a hard drive, and they can support hundreds of players. If this is a side-project for the typical hobbyist, use the HDD and have fun

Share this post


Link to post
Share on other sites
thanks all who responded.

My question is pretty much answered. I guess the database can somehow store data efficiently. although i dont really dont know why, but i will take your word for it, because i dont want my game to have as many problems as everquest!

Now, its time for me to learn to use MySQL. I hope its easy.

Share this post


Link to post
Share on other sites