Using STMT_CACHE

Hello, somebody can comment to me on the advantages to use the environment variable STMT_CACHE. Solaris 10 + Informix 10.00FC5W5 + HDR (OLTP) Thank you very much _________________________________________________________________ MSN Amor: busca tu ½ naranja http://latam.msn.com/amor/

Hi These are the advantages of using SQL Statement Cache feature. 1)Reduced memory consumption because query data structures are shared among different users. 2)Faster query processing time because for statements present in the cache, the database server can skip parsing and optimization phases, thereby giving a better response to queries. When the SSC feature is turned on, the database server does the following: 1. When a user *user1* fires an SQL statement, the database server checks the statement cache to see if an identical statement is present or not. 2. If the statement is not present in the cache, then the database server will parse, optimize and execute the statement. It will also check if this statement qualifies to be entered in the cache. If it does, then it will add entry into the cache for the statement. 3. When user *user2* executes the same statement, the database server will check the cache and find this statement in the cache. So it will not parse and optimize the statement again. It just executes the statement using the information in the cache. You can check the following article for more details : http://www-128.ibm.com/developerworks/db2/library/techarticle/0310iyer/0310iyer. html Thanks Ravi On 7/11/07, Juan Pablo <in4mixperu@hotmail.com> wrote: > > Hello, somebody can comment to me on the advantages to use the environment > variable STMT_CACHE. > > Solaris 10 + Informix 10.00FC5W5 + HDR (OLTP) > > Thank you very much > > _________________________________________________________________ > MSN Amor: busca tu ½ naranja http://latam.msn.com/amor/ > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > >