[Tilesathome] Using RAM-drive for ROMA temp tables

Matthias Julius lists at julius-net.net
Tue Dec 9 16:28:05 GMT 2008


Dirk Stöcker <openstreetmap at dstoecker.de> writes:

> On Tue, 9 Dec 2008, Matthias Julius wrote:
>
>>> If on the other hand a standard interface can be established, so that
>>> e.g. the server is faster when a "strip-xxx" request is done, but a
>>> non-stripped request can be delivered nevertheless (as default) I would
>>> say this could be a fine solution.
>>
>> The goal here is to make the database faster by limiting the amount of
>> data that is stored in there.  So if a server only supports the
>> "strip-xxx" request and no regular request it can do no harm.
>
> I do not know how databases work in detail nowadays, but I thought not the 
> amount of data itself is the limiting factor but the way it is stored. So 
> when storing is optimized for certain requests a speedup should possible 
> even without removing any information.

True, there is probably room for improvement.

Matthias




More information about the Tilesathome mailing list