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 database retrieval parameters to achieve
the correct balance between data retrieval and performance.
About this task
The database engine processes the number of rows specified
and then the screen is refreshed. However, if you are monitoring the
interactive behaviour of another application, this action might slow
the overall process because the screen is refreshed many times. The
Database Retrieval Parameters pane provides a tuning option for interface
or retrieval.
Procedure
- From the workbench menu bar, click . The Database Retrieval Parameters pane is displayed
in the Preferences window:
- Enter the number of rows that you want to retrieve for
each request.
- Drag the refresh rate slider to the refresh value that
you want.
- Click OK. When you run
a search or query, the plug-in reads data from the host until the
number of rows of data that you specified are displayed. The number
of resources retrieved is displayed in the status area at the bottom
of the view. If there are more resources to retrieve, the Retrieve
more button is available. Click Retrieve more to
fetch the next resources, up to the limit.
In the following example,
the number of rows to retrieve is set to 200 and the first 200 resources
are displayed. If you click Retrieve more,
the query or search pauses again after 400 resources are retrieved.