PeterJ
Posts: 90
|
| Posted: 07/26/2007, 11:39 PM |
|
Hi
I've been using Google Maps linked to a grid with a small number of records, about 300, showing locations. The visitor clicks on a link in the grid and the corresponding location is displayed. It has worked well. However I decided to use a map linked to a database containing 3500 records and I now the connection times out.
Does anyone know if there is a limit to the number of records that can be linked to Google Maps?
Thanks
|
 |
 |
Wkempees
|
| Posted: 07/27/2007, 4:09 AM |
|
How did you do the Google Maps, did you do your own coding or use a
third party tool (like CCT GoogleMaps) in the latter I would contact the
vendor.
Connection time out, on the Google sode of thing or on the SQL side?
Walter
|
|
|
|
PeterJ
Posts: 90
|
| Posted: 07/27/2007, 4:53 AM |
|
Hello Walter
I used CCT GoogleMaps. You are right, i should ask the vendor and I will. I was wondering if anyone had experienced the same issue.
Peter
|
|
|
|
DonB
|
| Posted: 07/27/2007, 5:57 AM |
|
Presumably they are not all visible at once, as they'd be too close together
for you to see most of the markers. You should be 'filtering' the set of
markers to eliminate overlaps and any outside the visible box before you
make a map.addmarker() call. It's the draw-time for the marker that is the
killer. Lots of discussion on optimizing techniques can be found in the
google maps api discussion group and mapki.com. Probably the best job of
handling large numbers or markers that I've seen implemented was at
ononemap.com.
--
DonB
http://www.gotodon.com/ccbth
"PeterJ" <PeterJ@forum.codecharge> wrote in message
news:546a9dca3ca65e@news.codecharge.com...
> Hello Walter
>
> I used CCT GoogleMaps. You are right, i should ask the vendor and I will.
I was
> wondering if anyone had experienced the same issue.
>
> Peter
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
PeterJ
Posts: 90
|
| Posted: 07/27/2007, 10:05 AM |
|
Hello DonB
The scale of the map is such that only one or two records would be displayed at a time. I have had a look at ononemap.com and here there are a large number of records being displayed on a larger map base. Far more than I want to display in the corresponding area. I think the cure may be to filter out those outside the map area but doesn't marry up with the ononemap example. I'm unable to display one record at the moment on a scale at street level.
I'll have a look at the discussion group you recommend for clues.
Peter
|
|
|
|
DonB
|
| Posted: 07/27/2007, 12:01 PM |
|
You evidently are creating many markers, even though 1 or 2 are visible?
Google's markers are horrendously slow to create. The better approach is to
use google's ajax interface to send the 'box' (visible area) to your server,
then retrieve only those points within that box. (fetch the map.bounds from
google API and send that back to the server. Use that to query the database
for displayable points and send back the lat/long of each one) Even a few
hundred points can be plotted in a reasonable amount of time this way.
Plus, the map will render, and then the markers wlll 'pop' in, giving a much
nicer user experience vs wating for the entire map+markers to be constructed
before it's displayed..
--
DonB
http://www.gotodon.com/ccbth
"PeterJ" <PeterJ@forum.codecharge> wrote in message
news:546aa25e163dbb@news.codecharge.com...
> Hello DonB
>
> The scale of the map is such that only one or two records would be
displayed at
> a time. I have had a look at ononemap.com and here there are a large
number of
> records being displayed on a larger map base. Far more than I want to
display in
> the corresponding area. I think the cure may be to filter out those
outside the
> map area but doesn't marry up with the ononemap example. I'm unable to
display
> one record at the moment on a scale at street level.
>
> I'll have a look at the discussion group you recommend for clues.
>
> Peter
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
PeterJ
Posts: 90
|
| Posted: 08/11/2007, 9:24 AM |
|
Hi
Quick update for anyone reading this post. Since I only wanted to display 1 record the problem was resolved by setting "Records Per Page" to 1. Loading time increases dramatically.
|
|
|
|
