Connected Query Processing Options

You can run a connected query using one of the following options:

• PeopleCode-based Preview XML

  Connected Query Report Developers use the Preview XML button to run a connected query using the application server when they build a new or edit an existing connected query. This option does not require saving the connected query to the database.

  See Using Connected Query Viewer.

• C++ based CQRuntime

  End users use the CQRuntime option to run a connected query using the Process Scheduler server. This method requires saving the connected query object to the database before running it.

  See Using Connected Query Scheduler.

• C++ based CQRuntime with the OrderBy Runtime option

  If you use C++ based CQRuntime with the OrderBy Runtime option, parent and child queries are dynamically altered to include the ORDER BY clause, every SQL statement runs once, and the connected query dramatically cuts the number of SQL statements that are generated at runtime. As a result, processing is faster and consumes fewer server resources.

  Note:

  Report developers can set the OrderBy processing option for all members or some members of the specific connected query.

  See the Using the OrderBy Processing Option section in Using Connected Query Manager.