i have a question about the general handling of the caching of procedures that are using the NOT VARIANT modifier.
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?