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 specified is reached, no more data is downloaded from the host. The number of resources retrieved is displayed in the status area. For example, if the limit is set to 200, the Resources view displays the first 200 rows of data. If there are more resources to retrieve, you can click Retrieve more to fetch the next resources, up to the limit. In this example, query or search pauses again after 400 resources 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.