Page Comparison

Commit Window Size

The number of UDRs (rows) to be removed between each database commit command. This value is used to tune the performance. If tables are small and contain no Binary Objects, the value may be set higher than the default. Default is 1000. The window size can be set to any value between 1-60000, where setting 1 means that commit is performed after 1 UDR, and setting 60000 means that commit is performed after 60000 UDRs.

This setting is only applicable if the Remove option is selected in the Source tab.

Generated SQL Statement

In this area the SQL statement to be used to query the database is shown. It may be used for debug purposes or for pure interest.

In order for the statement to appear, the Source and Assignment tabs have to be properly configured. If not, information about the first detected missing or erroneous setting is displayed.