JDBC Type 4 Driver Programmer's Reference for SQL/MX Release 3.2.1
MFC. If the most frequently used statements number is not known, it is recommended that you
configure a number closer to 60% of total queries in the application.
For example, if the application has 1000 unique queries, configure DSC
(t4sqlmx.maxStatements) to 600. The applications with more number of queries configured
in the DSC, cause memory swap. Therefore, reduce the DSC number and increase the queries in
the MFC.
The JDBC/T4 driver, in memory, caches the most frequently used statements.
MFC Limitations
MFC is not a replacement for the JDBC T4 Driver Side Cache (DSC); the JDBC T4 driver side cache
has a better response time than MFC.
When the module is created the first time, the MFC-related module file creation process consumes
more time for compilation.
For more information on MFC limitations, see the HP NonStop Connectivity Service Manual for
SQL/MX Release 3.2.1.
72 Module File Caching (MFC)