How to effectively display elements on a Google map in the user's viewing range?

Question

When a user moves a Google map, I would like to automatically display items in the user's viewing range. How can I display items efficiently and quickly?

I have a basic understanding of calling the getBounds () method every time the user moves the map, but I'm not sure how I can efficiently search and retrieve elements from my database within the lat / lg borders of the current viewport. Is there a simpler and quick way to do it?

Answer 1

Geek, Geohash. . MySQL, PostgreSQL SQL Server 2008 ( ), .

Answer 2

. , , .

• long/lat
• long lat
• SELECT * FROM table WHERE long > $long_left AND long < $long_right AND lat > $lat_bottom AND lat < $lat_top

MarkerManager , , .

/ , .

( :-)) , .