Using Read-only, Forward-only Dynaset

If your application does not need scrollable dynaset, then you can create forward only dynaset with ORADYN_NOCACHE (H8) option. With this option, performance improvement can be gained by eliminating the overhead of creating local cache file and the overhead of reading/ writing data from that file.

If the application does not make any update to the dynaset, then you can create read-only dynaset with ORADYN_READONLY (H4) option. With this option, performance improvement can be gained by eliminating the overhead of local parsing of SQL statement and reducing network trips for SQL statement execution.