[OSM-talk] [OSM-dev] donating read-only api-mirrors

Tom Hughes tom at compton.nu
Fri Feb 6 15:52:04 GMT 2009


Stefan de Konink wrote:
> Tom Hughes wrote:
>
>> That limit is not (primarily) about the cost of gathering the required 
>> data, though obviously that might become an issue as well, it's about 
>> the fact that we are holding the whole result set in memory (several 
>> times over in fact) on the rails server and those servers only have a 
>> finite amount of memory.
> 
> In that case; it seems to get more valid for lookup to switch to a slave 
> server that doesn't. The generation of XML is only a translation task of 
> SQL, and even that can be done streaming :)

Yeah, it really is that simple, which is why us simple minded idiots 
that run the server are still doing it all in memory.

Tom

-- 
Tom Hughes (tom at compton.nu)
http://www.compton.nu/




More information about the talk mailing list