Rdb Database Driver Performance

The default of Rdb is to open tables in read/write mode unless told otherwise. The Server supports read/write operations, so this is appropriate behavior. However, Rdb read/write operations consume more resources and are slower, even if just a select is being done. Applications can set Rdb opens to Read-only on a per request basis or a per session basis to enhance resource usage and speed performance. In either case, a commit should be done to ensure that prior work is complete.

On a session basis, add the following to the EDASPROF.PRF after the SQL SQLRDB SET SERVER command:

SQL SQLRDB COMMIT ;
SQL SQLRDB SET DECLARE TRANSACTION READ ONLY ;

On a per request basis (for example, immediately before a TABLE request) the usage is:

SQL SQLRDB COMMIT ;
SQL SQLRDB SET TRANSACTION READ ONLY ;


iWay Software