SQL Server drivers performance
SQL Server ODI drivers based on FreeTDS, Easysoft and MS ODBC have been reviewed to achieve better execution times.
Starting with Genero BDL 3.20, the FTM, ESM and SNC drivers for Microsoft® SQL Server use now the ODBC API
SQLExecDirect()
for any sort of SQL statement. In prior versions, the drivers use
SQLPrepare()
+ SQLExecute()
for common SQL statements such as
SELECT
, INSERT
, UPDATE
,
DELETE
.
Other improvements have been done, such as setting the ODBC cursor name
(SQLSetCursorName()
) only when needed, namely for SELECT
statements with FOR UDPATE
clause.
This leads to a reduction in the number of sp_cursor*
stored procedure calls and
shows a noticeable improvement in performance, especially in a client/server configuration where
each sp_cursor*
call results in a network round trip.