When creating the Flickr bot I had the same problem. I'd recommend you to use the specific per-country tables. The problem is, the fields change from table to table, but it's orders of magnitude faster (in my case, from 8 seconds per query to 0,1 seconds or something like this).
Joan Creus.
2012/9/4 emijrp emijrp@gmail.com
Yes, it is what I do, generate KML every some hours. ; )
API is really slow for live use.
2012/9/4 Andre Koopal andre@molens.org
Hi Emijrp,
On irc, you made a comment about the api being slow, can it be an idea that for example nightly, you create the needed kml files for your mappings from the database with a cron, and use that? That way, you get the fixes from users as well, and people will see that more and more pictures are coming. You should check with the others about timings, to make sure that you create everything after the updates from the various sources are done.
Regards,
Andre
On Tue, Sep 04, 2012 at 01:06:38PM +0200, emijrp wrote:
Added Ukraine and Serbia:
You both have coordinates out of your countries. Fix them or remove them from lists, and map will be updated in the next days, and will be zoom
in
your country.
Also added Mexico:
2012/8/28 emijrp emijrp@gmail.com
Hi, I'm making maps for WLM, if you need a map for your country and
have
lists with coordinates, contact me http://toolserver.org/~emijrp/wlm/
-- Emilio J. Rodríguez-Posada. E-mail: emijrp AT gmail DOT com Pre-doctoral student at the University of Cádiz (Spain) Projects: AVBOT http://code.google.com/p/avbot/ | StatMediaWiki<
http://statmediawiki.forja.rediris.es%3E
| WikiEvidens http://code.google.com/p/wikievidens/ | WikiPapers<
http://wikipapers.referata.com%3E
| WikiTeam http://code.google.com/p/wikiteam/ Personal website: https://sites.google.com/site/emijrp/
-- Emilio J. Rodríguez-Posada. E-mail: emijrp AT gmail DOT com Pre-doctoral student at the University of Cádiz (Spain) Projects: AVBOT http://code.google.com/p/avbot/ | StatMediaWikihttp://statmediawiki.forja.rediris.es | WikiEvidens http://code.google.com/p/wikievidens/ | WikiPapershttp://wikipapers.referata.com | WikiTeam http://code.google.com/p/wikiteam/ Personal website: https://sites.google.com/site/emijrp/
Wiki Loves Monuments mailing list WikiLovesMonuments@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments http://www.wikilovesmonuments.org
Wiki Loves Monuments mailing list WikiLovesMonuments@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments http://www.wikilovesmonuments.org
-- Emilio J. Rodríguez-Posada. E-mail: emijrp AT gmail DOT com Pre-doctoral student at the University of Cádiz (Spain) Projects: AVBOT http://code.google.com/p/avbot/ | StatMediaWikihttp://statmediawiki.forja.rediris.es | WikiEvidens http://code.google.com/p/wikievidens/ | WikiPapershttp://wikipapers.referata.com | WikiTeam http://code.google.com/p/wikiteam/ Personal website: https://sites.google.com/site/emijrp/
Wiki Loves Monuments mailing list WikiLovesMonuments@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments http://www.wikilovesmonuments.org