From 6a260fe9268d60103c3578b61c51194d991e6da2 Mon Sep 17 00:00:00 2001 From: Damien Regad Date: Mon, 15 Mar 2021 19:28:32 +0100 Subject: mssql: enable InsertID capability by default Fixes #692 --- drivers/adodb-mssqlnative.inc.php | 9 +++++---- 1 file changed, 5 insertions(+), 4 deletions(-) (limited to 'drivers/adodb-mssqlnative.inc.php') diff --git a/drivers/adodb-mssqlnative.inc.php b/drivers/adodb-mssqlnative.inc.php index 3b9d905a..26907fe5 100644 --- a/drivers/adodb-mssqlnative.inc.php +++ b/drivers/adodb-mssqlnative.inc.php @@ -50,12 +50,13 @@ class ADODB_mssqlnative extends ADOConnection { var $fmtDate = "'Y-m-d'"; var $fmtTimeStamp = "'Y-m-d\TH:i:s'"; /** - * While the driver does have InsertID capability, the functionality is - * turned off by default for performance reasons. - * Switch it on as needed by calling {@see enableLastInsertID()}. + * Enabling InsertID capability will cause execution of an extra query + * {@see $identitySQL} after each INSERT statement. To improve performance + * when inserting a large number of records, you should switch this off by + * calling {@see enableLastInsertID enableLastInsertID(false)}. * @var bool $hasInsertID */ - var $hasInsertID = false; + var $hasInsertID = true; var $substr = "substring"; var $length = 'len'; var $hasAffectedRows = true; -- cgit v1.3