7 Replies Latest reply on Jun 22, 2017 7:26 AM by Ramesh Reddy

    teiid caching and performance optimization parameters

    Sanjeewa Ranasinghe Newbie

      Hi,

       

      I'm developing a data virtualization layer using teiid which will serve data to the front end side. I need to performance tune teiid to access large volume of data and provide the result data to the front end side with optimum performance. I'm thinking about using caching to improve performance. I have the fallowing questions

       

      1. When result set caching or materialized views are used when will teiid start using disk storage instead of main memory. How memory and disk space utilized when caching is enabled
      2. How to handle max-reserve-kb, memory-buffer-space like parameters in the buffer manager. what are the optimum values. what are the references I can refer