Capturing SQL statements for client optimization

The process of capturing SQL statements involves two steps: setting the values of certain properties and then running your application.

In the capture process, you run your application after first setting the property captureMode to ON. pureQuery creates a file that lists the SQL statements, as well as stack traces. The file is called a pureQueryXML file and you can specify its extension as either .pdqxml or .xml.

When you run your non-pureQuery API application with captureMode set to ON, you must run successfully all logic paths that contain the SQL statements that you want to run statically. pureQuery captures SQL statements only when they are run successfully.

General considerations


Feedback