MX 2.x)

Module File Caching (MFC)

HP NonStop ODBC/MX Driver for Windows—527888-004

4-2

MFC Usage Scenarios

The benefits of lower processor and memory utilization mentioned below are

applicable on the NonStop Server:

•

ODBC/MX applications using SQLPrepare() have the benefit of lower processor

utilization, lower memory consumption, and better response time.

•

ODBC/MX applications using complex queries through prepare calls have higher

benefit of lower processor utilization, lower memory consumption, and better

response time.

•

ODBC/MX applications, which have large number of statements that are SQL

compiled at the startup, can benefit from reduced (re-) startup time by using the

MFC feature. In situations, where servers are configured for automatic restart, the

startup time is reduced.

MFC Limitations

For information on MFC limitations, see the HP NonStop SQL/MX Connectivity Service

Manual.

Troubleshooting MFC

For information on troubleshooting, see the HP NonStop SQL/MX Connectivity Service

Manual.