[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