Setting database retrieval parameters

You can use the database retrieval parameters pane to alter settings that affect how database rows are retrieved and data is refreshed. These settings are dependant on a variety of factors such as the speed of your connection and the size of your database. Alter these settings until you get a combination that gives you the performance you want. It is advisable to start with a relatively small number such as 100, you can then alter this to be a higher value, for example 10000 rows.

About this task

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

Procedure

  1. Click Window > Preferences from the workbench menu bar, and click Database retrieval parameters. The Database retrieval parameters pane is displayed in the Preferences view. The example below shows a screen capture of the Database retrieval parameter pane.
    A screen capture showing the database retrieval parameters
  2. Enter the number of rows that you want to retrieve. You can use the up and down arrows to alter the value.
  3. Drag the data refresh rate slider to the value that you want.
  4. Click OK. The number of rows of data that you specified are displayed. You can click the retrieve more button to display 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
    If you want to retrieve more records using the value that you specified, click the Retrieve more button.