Static SQL cache is removed

The Static SQL Cache has been removed.

Before version 2.00, the size of the static SQL cache is defined by an FGLPROFILE entry:

dbi.sql.static.optimization.cache.size = max

This entry was provided to optimize SQL execution without touching code using a lot of static SQL statements, especially when using non-Informix® database servers where the execution of static SQL statements is slower than with Informix. This is useful for fast migrations, but there were a lot of side effects and unexpected errors.

Starting with version 2.00, the Static SQL Cache has been removed for the reasons described. Programs continue to run without changing the code, but if you want to optimize program execution, you must use dynamic SQL (PREPARE + EXECUTE).