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 <[email protected]> > Yes, it is what I do, generate KML every some hours. ; ) > > API is really slow for live use. > > > 2012/9/4 Andre Koopal <[email protected]> > >> 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: >> > * http://toolserver.org/~emijrp/wlm/serbia/ >> > * http://toolserver.org/~emijrp/wlm/ukraine/ >> > >> > 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: >> > * http://toolserver.org/~emijrp/wlm/mexico/ >> > >> > 2012/8/28 emijrp <[email protected]> >> > >> > > 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> >> > > | WikiEvidens <http://code.google.com/p/wikievidens/> | WikiPapers< >> http://wikipapers.referata.com> >> > > | 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/> | >> > StatMediaWiki<http://statmediawiki.forja.rediris.es> >> > | WikiEvidens <http://code.google.com/p/wikievidens/> | >> > WikiPapers<http://wikipapers.referata.com> >> > | WikiTeam <http://code.google.com/p/wikiteam/> >> > Personal website: https://sites.google.com/site/emijrp/ >> >> > _______________________________________________ >> > Wiki Loves Monuments mailing list >> > [email protected] >> > https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments >> > http://www.wikilovesmonuments.org >> >> >> _______________________________________________ >> Wiki Loves Monuments mailing list >> [email protected] >> 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/> | > StatMediaWiki<http://statmediawiki.forja.rediris.es> > | WikiEvidens <http://code.google.com/p/wikievidens/> | > WikiPapers<http://wikipapers.referata.com> > | WikiTeam <http://code.google.com/p/wikiteam/> > Personal website: https://sites.google.com/site/emijrp/ > > > _______________________________________________ > Wiki Loves Monuments mailing list > [email protected] > https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments > http://www.wikilovesmonuments.org >
_______________________________________________ Wiki Loves Monuments mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments http://www.wikilovesmonuments.org
