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.rozeb...@iowa.gov



Reply via email to