[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: How many records in a table?

  • Thread starter Thread starter Rob Fitzpatrick
  • Start date Start date
Status
Not open for further replies.
R

Rob Fitzpatrick

Guest
Gus, A couple of examples come to mind, there are probably others. - D&L: after the fact, I want to compare record counts in source and target. I use tabanalys for this but it can be time-consuming on large DBs. And compared to others here, my "large" DBs are quite small. - looking at CRUD stats. I was doing this today. Looked at a test DB and found a huge number of reads on a table. I tracked down the program and found an unbracketed query. I wanted to know whether, given the number of times the program had been run, this would account for the reads I saw. So I wanted to know how many records were in the table, to see the cost of each table scan. In cases like this an approximate count is good enough.

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