Displayed Records

Avatar
  • updated
  • Answered

Previously, in version 3.3.3.3, the number of records returned was modulated by the SELECT statement only.  Since we have upgraded (now in version 3.5.2.0), there is a dropdown to display 100, 1000, 10000 or 100000 records.  I do not see an option to select "all".  Please advise.

Avatar
Anonymous

Thank you for your feedback.

1) To display the "All" option, go to the Connection Properties dialog, click the "More Options..." button, switch to the Advanced tab and check the "Fetch records on demand" option.

Please note that working in this mode is not safe as it may lock the table for other users while browsing. In the default mode, all records are fetched at once, so if there are too many records it will cause Out of Memory error, that's why we turned off the ability to select all records. If 100000 records are not enough to browse at a time, please consider applying filters to your data.

Avatar
Andrey Zavyalov, PM
  • Answered