When I query from a very large table, the data grid does not display all the records that should be returned, even if I try to fetch to the last record.
Limitation of PC's memory does not allow all records from the table to be displayed.
WORKAROUND:
None
STATUS:
Waiting for enhancement to be included in a future version of Toad for Oracle.
The enhancement is to have TOAD discard some data, when the user scrolls down the table. The data displayed will be up to 100,001, 100,002, 100,003 and so on. The actual data held in TOAD will be between rows 2 and 100,001, rows 3 and 100,002, rows 4 and 100,003 respectively. The data before row 2, 3, 4 will be "freed" or "discarded" from the memory of the PC. That is, the list box for Toad DATA section will hold a specified number of rows. As a user moved down (or scrolls down) the list box, the data at the top of the list box will be "discarded" to make room for the new data. Vice versa, when the user scrolls up the list box, the bottom rows of data will be "freed" to make room for top rows of data. Thus, there are no memory issues.
