Thanks,
I will try this.
William Andrew
--- On Tue, 1/5/10, Mike Williams <nos...@econym.demon.co.uk> wrote:
From: Mike Williams <nos...@econym.demon.co.uk>
Subject: Re: how to tie these programs together,using php-mysql,MyAdmin
To: Google-Maps-API@googlegroups.com
Date: Tuesday, January 5, 2010, 11:17 AM
One thing you could do is:
1. Change map.php so that it only sends geocode requests for locations
for which your database doesn't already hold lat/lng values. This will
make it run an awful lot faster in circumstances where the houses
haven't moved, and also stop you wasting your geocoding quota.
2. Remove the include('phpsqlajax_genxml3.php'); from map.php.
3. In phpsqlajax_map.hm add this line
GDownloadUrl("map.php", function(data) { }
If you need the data to be absolutely up to date, then instead of { }
you could wait for the completion before calling
GDownloadUrl("phpsqlajax_genxml3.php", function(data) { ...
but the downside of that is that the first user after a big database
change might have to wait a while for the data.
In this way, whenever someone looks at your page, both servers scripts
get run.
A more conventional approach would be to leave phpsqlajax_map.hm and
phpsqlajax_genxml3.php exactly as they are, and arrange to run map.php
whenever you have updated the database.
That has the advantage that you can arrange for geocoding failures to be
reported to you, so that you can go back into your database update and
fix any address typos promptly.
--
Mike Williams
http://econym.org.uk/gmap
--
You received this message because you are subscribed to the Google Groups
"Google Maps API" group.
To post to this group, send email to google-maps-...@googlegroups.com.
To unsubscribe from this group, send email to
google-maps-api+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/google-maps-api?hl=en.
--
You received this message because you are subscribed to the Google Groups
"Google Maps API" group.
To post to this group, send email to google-maps-...@googlegroups.com.
To unsubscribe from this group, send email to
google-maps-api+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/google-maps-api?hl=en.
