Dmitry, > > Splitting temp destinations into e.g. RAM disk and if this is > > exhausted to regular disk is getting more and more popular, but due to > > CORE-2422, > > So far nobody has proved that this approach is better than adjusting > TempCacheLimit.
I don't see the TempCacheLimit as being related to what Thomas is trying to achieve. There are some queries which will generate temp results which will exceed any amount of RAM/TempCache that can be added to a server. When that happens, the temp results will be written to disk. What Thomas is looking to define is a setup where an RAM would be the first device for the temp results (to enable much faster processing -- RAM disk has 100x IO of even an SSD!!), with any excess falling to an SSD or HDD. The approach/setup is perfectly reasonable -- it tries to place temp data on devices which will provide the greatest benefit. Sean ------------------------------------------------------------------------------ Virtualization & Cloud Management Using Capacity Planning Cloud computing makes use of virtualization - but cloud computing also focuses on allowing computing to be delivered as a service. http://www.accelacomm.com/jaw/sfnl/114/51521223/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
