Setting database retrieval parameters

When you retrieve data from a database the performance of your workstation can be adversely affected by the amount of data being retrieved and the rate at which the screen is refreshed to display the data. You can adjust the settings on database retrieval parameters pane to achieve the correct balance between data retrieval and performance.

About this task

The database engine processes the amount of rows specified and then the screen is refreshed. However, if you are monitoring the interactive behaviour of another application this might slow the overall process down because the screen is refreshed many times. The database retrieval parameters pane provides you with a tuning option for interface or retrieval.

Procedure

  1. From the workbench menu bar, click Window > Preferences > Database retrieval parameters. The example shows the Database retrieval parameter pane.
    A screen capture showing the database retrieval parameters
  2. Enter the number of rows for each request that you want to retrieve.
  3. Drag the refresh rate slider to the refresh value that you want.
  4. Click OK. When you next make a selection in the records view the number of rows of data that you specified are retrieved and displayed. You can click the Retrieve more button to retrieve more rows of data. The number of rows that are retrieved is based on the number you previously specified.
    screen capture showing the retrieved data