what is the best way to store a lot of markers in database?
I suppose that amount of markers will be huge, so i decided to store markers in database using tiles:
You can see picture explaining this over here
So for example, at the beginning the coordinates of client viewport are determined and the tiles to be loaded from the server are calculated, after that the server determine the markers that are whithin the requested tiles and sends them to the client.
My question is what is the best way to organise the database that will store markers by tiles?
Can smn show an example or there is already a standart solution to this problem?
2 Solutions collect form web for “what is the best way to store a lot of markers in database?”
I think you are over-complicating this. If the only thing you are storing is the markers (lat & lon), then a single database table will do.
If you are planning to work with a large amount of markers, definitely take a look at google fusion tables:
And you can read more about it here: