We are trying to implement a complex web application that has access to our legacy ISAM GEN.4 and 5 data files via AcuXDBC. One of the common uses of the app is searching and paging through results. We thought AcuXDBC would be perfect for this, however it seems that support for paging is somewhat broken.
There are two issues we have with this:
(1) SKIP and TOP are undocumented, yet exist and work.
(2) SKIP doesn't appear to be at all performant, appearing to internally do a full table scan and simply omit the skipped results.
Am I missing something here? Should this be working better, or is it undocumented because it doesn't work correctly?