[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: Speed up Grid DataSource Content loading (Count function)

  • Thread starter Thread starter Dustin Grau
  • Start date Start date
Status
Not open for further replies.
D

Dustin Grau

Guest
If you have a table with 1,000,000 records, and you provide no filter when initially searching (opening the view), then yes all 1,000,000 records will be counted. If you narrow your results by use of a filter (fields begins "a") then only the count of ALL MATCHING records will be returned, so 1,000 in your example. In either case, if you are using server-side paging only the first X records will be returned, but the full count will always be returned based on the filter used.

Continue reading...
 
Status
Not open for further replies.
Back
Top