From: Karen Abgarian <abvk Date: April 9 2012 6:47pm Subject: Re: Commit commands with SELECT List-Archive: http://lists.mysql.com/mysql/227157 Message-Id: <63A1E303-F148-4E6D-AB27-2A40C4F87916@apple.com> References: MIME-Version: 1.0 Content-Type: text/plain; CHARSET=US-ASCII Content-Transfer-Encoding: 7BIT 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 > > >