Informix

 View Only
  • 1.  Better performance with temp dbspace in RAM disc?

    Posted Wed November 30, 2022 09:24 AM
    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


  • 2.  RE: Better performance with temp dbspace in RAM disc?

    Posted Wed November 30, 2022 11:31 AM
    Hi Marc.

    We certainly have and it can make a big difference:

    https://www.oninitgroup.com/faq-items/ram-disk-and-informix

    ------------------------------
    Doug Lawry
    Oninit Consulting
    ------------------------------



  • 3.  RE: Better performance with temp dbspace in RAM disc?

    IBM Champion
    Posted Wed November 30, 2022 01:17 PM
    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
    ------------------------------