Limiting the amount of data downloaded

You can limit the amount of data that is retrieved to prevent downloading too much information from the host to the client PC. To change the limit, click Window > Preferences > Database Retrieval Parameters. The default limit is 10000.

When the limit that you have specified is reached, no more data is downloaded from the host and a window opens at the bottom of the screen. For example if the limit is set to 200, the Resources view stops reading any more data after 200 rows are retrieved. You can click Retrieve more to fetch another amount of rows that you have specified, for example 200. In this example, the search pauses again when 400 rows are retrieved.

The speed of the available connection determines the appropriate fetch size limit. As a general rule, make the limit as large as the memory allows without affecting performance.