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
- From the workbench menu bar, click . The example shows the Database retrieval parameter
pane.
- Enter the number of rows for each request that you want
to retrieve.
- Drag the refresh rate slider to the refresh value that
you want.
- 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.