Another clarification, ppg's are not limited only by disk space, just like all other databases the maximum size of cachetemp can be set to stop infinite growth, this means the ppg's have the same limit.

Also remember, the more you use them the more cachetemp fills.

One last point is that other parts of cache such as odbc queries also use cachetemp for storage and so the whole of cachetemp is not always available.

As ever you have to plan usage appropriately based on the application and the database configuration.

Thanks for the update, I will study the tuning article in case it throws up anything new and also plan to do some benchmarking.

Thanks for bringing this up, I had forgotten to review this issue myself.  I would assume any performance loss could be negated using Cache's own buffers.