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

  • Thread starter Thread starter pknopfgfa
  • Start date Start date
Status
Not open for further replies.
P

pknopfgfa

Guest
I have the same issue, as some of my tables have over 15M rows. I created a sequence for the table and set its current value to the select count(*) of the table. I then created a create and delete trigger on the table to increment the sequence up and down. In the count method I simply got the current value of the sequence. It’s pretty instantaneous then… Hope this helps. Let me know if you need the code but it’s fairly straightforward.

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