Setting the Maximum Number of Rows Fetched

By default, RDC retrieves a maximum of 1000 rows of data (records) whenever you open the Home page or execute a search.

You can change the default value by adding the max_row_fetched parameter to the RdcConfig.properties file. You specify the maximum number of rows that RDC can retrieve from the database at a time. When you execute a search, RDC issues a warning message to adjust the search criteria if your query would retrieve more rows than the maximum number allowed.

Note:

Increasing the value is likely to degrade performance. Reducing the value may improve performance for any given search, but may require more searches to be executed by the user.

To change the maximum number of rows fetched:

1. Log in to the RDC application server.
2. Navigate to the OPA_CONFIG_FOLDER. The path is determined by the registry entry opa54 under HKEY_LOCAL_MACHINE > Software > Oracle.
3. Open the rdcConfig.properties file with a text editor.
4. Update the value for max_row_fetched in the file. The default value is 1000.
5. Save your changes.