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:
> * 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 <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)
> > 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)
> _______________________________________________
> 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)

_______________________________________________
Wiki Loves Monuments mailing list
WikiLovesMonuments@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments
http://www.wikilovesmonuments.org