NEW ENHANCEMENTS AVAILABLE FOR MERTECH'S FLEX2SQL DRIVERS
The two enhancements, both related to embedded SQL, are valid for all four drivers (MS SQL, Oracle, PostgreSQL, and MySQL).
Increased speed when fetching multiple rows
While rows are served to the Dataflex application one row at a time, in the background the driver will now by default fetch ten rows at a time. The command SQL_EXECUTE_STMT has
been extended to now take an optional argument:
SQL_EXECUTE_STMT ROWCOUNT [row count (defaults to 10)]
Where the developer can select how many rows to fetch in one go.
This has a similar impact on performance as the regular row count feature for Dataflex FINDs, that all drivers have.
Improved performace when using embedded SQL
The second improvement is that when using embedded SQL
and binding into variables (using SQL_FETCH_NEXT_ROW INTO col1, col2), has been rewritten with significant performance gains.
To take advantage of the first feature, a new driver is needed,
to take advantage of the second one, the application needs
to be recompiled with the latest mertech.inc. All of which
are available for download.










