31 reputation
2
bio website pikajuna.com
location Slovenia
age 28
visits member for 2 years, 11 months
seen Jul 2 '13 at 8:13

Apr
17
awarded  Popular Question
Nov
2
comment How to efficiently store and display a tile map on the web?
I agree, your answer gave me a lot of food for thought. I will try to find a way to keep serialized map data in memory and keep the database as a backup. But then I have to figure out how to share changes between the players. I will get back with what I come up with after I do some further testing.
Nov
2
comment How to efficiently store and display a tile map on the web?
Sorry for the confusing math, there is also twice the space between the players in addition to the player zone so that they are an equal distance from each other, which makes it 90k. Querying is not a problem. Selecting 90k tiles and building a map is. But it's not a good way to do it. I will serialize the map data and use query the tiles in the db when detailed information is requested.
Nov
2
comment How to efficiently store and display a tile map on the web?
I'm building a competitive transport tycoon, think of OpenTTD, a map the size of 512x512 (262k) is not that big for a couple of players. I realize that it's ambitious, but if the map is not that big, the game would end too soon. Because it's a multiplayer game I need to sync the changes to the map between players. My first instinct was to just use the concepts I know from web development and go with a datbase. It doesn't need to be super realtime. I'm going with JS visualization, because I'd like to have dynamic stuff on the map.
Nov
2
awarded  Student
Nov
1
asked How to efficiently store and display a tile map on the web?