Propriété enableDynamicSQLReplacement

If you added alternative SQL statements to a pureQueryXML file and did not bind those statements, this option specifies whether to run those statements.

After you capture SQL statements in a pureQueryXML file, you might discover that one or more statements do not perform as well as your application requires. However, because you discover this fact late in your development cycle, modifying the application might not be possible. You can edit the pureQueryXML file by adding an alternative SQL statement for each SQL statement that is underperforming. When you run your application, pureQuery uses the alternative SQL statements, instead of the SQL statements that you originally captured.

You can choose whether to bind the alternative SQL statements after you add them. If you do not bind them but want to use them, you must set the enableDynamicSQLReplacement property to TRUE when you run your application.

Cette propriété peut posséder les valeurs suivantes :

TRUE
Specifies to run the alternative SQL statements. pureQuery runs them dynamically because they are not bound.
FALSE
Specifies not to run the alternative SQL statements. Instead, pureQuery runs the original SQL statements that are in the pureQueryXML files that your application uses.
This is the default value.

Commentaires