Return-Path: Delivered-To: apmail-ibatis-user-java-archive@www.apache.org Received: (qmail 12317 invoked from network); 15 Aug 2006 12:07:54 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 15 Aug 2006 12:07:54 -0000 Received: (qmail 24835 invoked by uid 500); 15 Aug 2006 12:07:52 -0000 Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org Received: (qmail 24816 invoked by uid 500); 15 Aug 2006 12:07:52 -0000 Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user-java@ibatis.apache.org Delivered-To: mailing list user-java@ibatis.apache.org Received: (qmail 24805 invoked by uid 99); 15 Aug 2006 12:07:52 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 15 Aug 2006 05:07:52 -0700 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_HELO_PASS,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: domain of lists@nabble.com designates 72.21.53.35 as permitted sender) Received: from [72.21.53.35] (HELO talk.nabble.com) (72.21.53.35) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 15 Aug 2006 05:07:51 -0700 Received: from [72.21.53.38] (helo=jubjub.nabble.com) by talk.nabble.com with esmtp (Exim 4.50) id 1GCxhj-0004sk-EB for user-java@ibatis.apache.org; Tue, 15 Aug 2006 05:07:31 -0700 Message-ID: <5812925.post@talk.nabble.com> Date: Tue, 15 Aug 2006 05:07:31 -0700 (PDT) From: DavidR To: user-java@ibatis.apache.org Subject: Re: batch insert autocommit setting In-Reply-To: <46d2280d0608150500n3be9a160k1ec6dfd120cfc399@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit References: <5811907.post@talk.nabble.com> <8267A5C8B2C7AD4DBE9C29304C6104DE01FD99FC@so1evn001.Office.local> <5812319.post@talk.nabble.com> <46d2280d0608150500n3be9a160k1ec6dfd120cfc399@mail.gmail.com> X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N I thought i saw around the forums that Ibatis automatically deals with this behind the scenes? Anyway, I cut down my test case to 1000 rows. Koka Kiknadze wrote: > > The only situation when batch may be noticeably slower compared to single > record inserts that I can imagine is when you try to insert too many rows > in > a single batch (so that databse starts choking trying to keep huge > rollback > data), what is your batch size? And which database? > > -- View this message in context: http://www.nabble.com/batch-insert-autocommit-setting-tf2108481.html#a5812925 Sent from the iBATIS - User - Java forum at Nabble.com.