[progress Communities] [progress Openedge Abl] Forum Post: What's The Fastest Way To Get...

[Richard Marsh]

I've looked at a number of different ways to do this, and the fastest I've found so far is to use proutil tabanalys. Using select count(*) is about the same speed. The interesting thing about proutil tabanalys is it reports on every table, in the same time that it takes for select count(*) to do one table. It takes less than half a second to report on nearly 1 million records over 200+ tables. So this makes me think that the information for each table must be stored somewhere, and that proutil tabanalys is just reporting on this information for every table. If so, how do I get this information for a specific table? Or is there a better method altogether?

Continue reading...