Optimize browsing large SQL Server or Oracle recordsets by using dynamic cursors

The dbdyngrd sample demonstrates how to use and take advantage of dynamic cursors when you are browsing SQL Server databases.

Dynamic cursors have the advantage that you can quickly jump to a given record without having to loop through all the records. So, if you know the record count of a result set you can call MoveLast or MoveFirst to instantaneously position the current record at the first or last record.

A further optimization the dbdyngrd sample demonstrates is the usage of a 'Select Count(*)' query to determine the record count.

To download the sample go to our customer area and search for dbdyngrd. The sample requires VC 5.0 or later. It works both with OG 6.0 and OG 6.1