Hello Erhan,
Do you experience this behavior only in Uniface 10? I did some digging in our knowledge base and it seems that one of my colleagues has raised this on the SQL Server Forum (some time ago):
The behavior seems to be caused by the Microsoft ODBC driver, if I understand it correctly.
Are you, however, sure that the performance issues you are experiencing are actually caused by these implicit transactions? From what I can see this will not be different in Uniface 9.
I hope this helps.
Kind regards
------------------------------
Daniel Iseli
Principal Technical Support Engineer
Uniface Services
Rocket Software, Switzerland
------------------------------
Original Message:
Sent: 05-02-2022 08:53
From: Erhan Gunbulut
Subject: Implicit transactions
Hello,
Is implicit transactions used within Uniface 10?
We have performance issues and our DBA finds implicit transactions even for a select statement. But I can't find anything in de source about using implicit transactions. Is there a way of turn if off?
Database is SQL Server 2016 and we use ODBC SQL Server driver for the connection.
greets,
Erhan Günbulut
------------------------------
Erhan Gunbulut
Sogeti Nederland B.V.
------------------------------