• No replies
31 Posts

Pinned topic Caching Questions with 'NOT VARIANT'

‏2013-06-03T10:21:23Z | caching informix server speed


i have a question about the general handling of the caching of procedures that are using the NOT VARIANT modifier.

(Informix 11.50FC9)

We noticed that procedure results were much faster when using NOT VARIANT - but this results to some questions:


- does this caching works limited on:  database , session and/or statement/procedure level? On database for sure or? Or does Informix notice the same procedure in another database?


- Is it possible to force a refresh/flush or the cash with a special statement or SPL?


Thank you,



Updated on 2013-06-03T10:21:45Z at 2013-06-03T10:21:45Z by MDCYP