Hey,

 

I am currently in the process of designing a game I have recently thought of. It is a web browser based MMORPG which I believe is quite unique how it works.

 

I have an issue I am thinking about which is about bandwidth and mass server load I may encounter from the game. The game relies on a big mysql database and the game runs queries every 0.5 seconds to keep the player updated on what is happening.

 

What I wont to know is, would that create a lot of strain on the server and will it require a lot of bandwidth? One other thing is that I am using Ajax to reload the data so the whole page wont be reloaded every time.

 

Thanks, Stanni

hiya,

 

funny you say your making a PBBG, me and my friend make them for fun... well... more making a future job to be honest... i dont get why your doing sql updates every 0.5 seconds tho... what is you game made with?

 

and the bandwith issue isnt really a problem if you rent a private rack and have master/master or master/slave sql clusters with giga ports on the servers as server 2 server communication in a private rack is free (99.9% of the time).

 

have you got a beta i can try?

hiya,

 

funny you say your making a PBBG, me and my friend make them for fun... well... more making a future job to be honest... i dont get why your doing sql updates every 0.5 seconds tho... what is you game made with?

 

and the bandwith issue isnt really a problem if you rent a private rack and have master/master or master/slave sql clusters with giga ports on the servers as server 2 server communication in a private rack is free (99.9% of the time).

 

have you got a beta i can try?

 

Hey,

 

Nice to see your on a similar project. First off Ill just tell you that I am in very early development so I don't have a beta to show to you but as soon as I do, id be glad to show you though.

 

Secondaly, my game works using basically tiles to make an image on the screen, so you might have say tiles that represent grass, pavements, water etc then in a database there will be a bunch of records with co'ords on them that refer to a tile on the map then next to each co'ord will be defined an image.

 

Then the map is put together by first seeing where the user is and then pulling all the tiles from the database that are around him.

 

the reason it needs to update so frequently is so you see the other users/monster moving around you, or is there a better way of doing this? :s

 

thanks, Stanni

 

P.S. Do you have a beta of your game to show me, id be very interested to see?