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
- 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.
- Enter the number of rows that you want to retrieve. You
can use the up and down arrows to alter the value.
- Drag the data refresh rate slider to the value that you
want.
- 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. If you want to retrieve
more records using the value that you specified, click the Retrieve more button.