If your temp tables are large or long lived then, yes, using a RAM disk for temp dbspaces will be a big win.
If you mostly use temp dbspaces for sorting and small or short-lived temp tables then sometimes not.
I think it is probably a good idea, but test it on your QA systems with a simulated production load and find out how it does for your systems.
Art
------------------------------
Art S. Kagel, President and Principal Consultant
ASK Database Management Corp.
www.askdbmgt.com------------------------------
Original Message:
Sent: Wed November 30, 2022 09:23 AM
From: Marc Demhartner
Subject: Better performance with temp dbspace in RAM disc?
Hello,
we have the workgroup edition, which is bound to 32GB shared mem. Some machines have 64GB RAM or more... so my idea came up to create a 24GB RAM disc and move the temp space in the ram disc.
Anyone tried that before? It should boost performance or ?
BR,
Marc
------------------------------
Marc Demhartner
------------------------------
#Informix