[Tilesathome] Using RAM-drive for ROMA temp tables

[Milenko]

Hey all,

 

                Has anyone played with using a ramdrive to store the temp
tables in map.fcgi?  There are 6 different temp tables used to store data
before it's dumped to the client.  I wonder if there would be a significant
speed increase if these could be stored in RAM instead of on disk.  The
script creates a "mirrored" tablespace before creating the temp tables, if
this tablespace where to point to a filesystem in RAM would that accomplish
this?  I currently have it set to a separate directory on disk, but nothing
is ever created there so I'm not sure if it's actually being used to
anything.

 

-Jeremy

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tilesathome/attachments/20081205/3f45b550/attachment.html>