I vote 1) yes 2) no
It could be result of the app developer's convenience to just wrap anything they submit to
the database in a transaction. Selects are not transaction but autocommit/commit do no
harm. That might be the thinking.
On 09.04.2012, at 11:38, Rozeboom, Kay [DAS] wrote:
> We have an application with blocks of code that begin with setting autocommit off,
> and end with a commit. The code in between does only selects, no updating.
> 1) Am I correct in thinking that the autocommit and commit statements don't
> really accomplish anything useful?
> 2) If the autocommit and commit statements are unneeded, do they add enough
> additional overhead that I should be concerned about them?
> Kay Rozeboom
> Information Technology Enterprise
> Iowa Department of Administrative Services
> Telephone: 515.281.6139 Fax: 515.281.6137
> Email: Kay.Rozeboom@stripped