Topic
  • No replies
MDCYP
MDCYP
31 Posts

Pinned topic Caching Questions with 'NOT VARIANT'

‏2013-06-03T10:21:23Z |

Hello,

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,

Marc

 

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