Florian Lohoff <[EMAIL PROTECTED]> writes: > On Fri, Dec 05, 2008 at 02:55:07PM -0500, Milenko wrote: >> 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. > > I tried with a different tablespace on seperate speedy disks and it > didnt make a difference as the linux kernel is clever enough to > not let these short lived tables hit the disk
That't what I would have guessed, too. If you have enough RAM to create a RAM drive the kernel also has enough memory to cache the data if you leave the memory to the kernel instead. Matthias _______________________________________________ Tilesathome mailing list [email protected] http://lists.openstreetmap.org/listinfo/tilesathome
