When I examine the output tab while opening the Data tab in the Database Browser, I notice the TDA does a select * from the appropriate table. This brings up a couple of questions:
We have a setting that allows us to limit the records retrieved via a data grid. Why is a select * from the table being done if we limit the records retrieved?
When we filter the records, in the data grid, is there another hit to the database to retrieve all of the records shown in the filter list? One might suspect that we already have the records if we’re executing a select * against the table. Is the list also subject to the limits established in the options for number of records to retrieve?