Return-Path: 
 <derby-user-return-6421-apmail-db-derby-user-archive=db.apache.org@db.apache.org>
Delivered-To: apmail-db-derby-user-archive@www.apache.org
Received: (qmail 98744 invoked from network); 16 Mar 2007 16:53:59 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 16 Mar 2007 16:53:59 -0000
Received: (qmail 6130 invoked by uid 500); 16 Mar 2007 16:53:57 -0000
Delivered-To: apmail-db-derby-user-archive@db.apache.org
Received: (qmail 6104 invoked by uid 500); 16 Mar 2007 16:53:56 -0000
Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
list-help: <mailto:derby-user-help@db.apache.org>
list-unsubscribe: <mailto:derby-user-unsubscribe@db.apache.org>
List-Post: <mailto:derby-user@db.apache.org>
List-Id: <derby-user.db.apache.org>
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Delivered-To: mailing list derby-user@db.apache.org
Received: (qmail 6092 invoked by uid 99); 16 Mar 2007 16:53:56 -0000
Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 16 Mar 2007 09:53:56 -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 (herse.apache.org: domain of Derek.Sedillo@ngc.com
 designates 155.104.240.104 as permitted sender)
Received: from [155.104.240.104] (HELO xmrm0101.northgrum.com)
 (155.104.240.104)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 16 Mar 2007 09:53:45 -0700
Received: from xbhm0001.northgrum.com ([155.104.118.90]) by
 xmrm0101.northgrum.com with InterScan Message Security Suite;
 Fri, 16 Mar 2007 09:45:20 -0700
Received: from xmbco501.northgrum.com ([158.114.104.70]) by
 xbhm0001.northgrum.com over TLS secured channel with Microsoft
 SMTPSVC(6.0.3790.2499);
	 Fri, 16 Mar 2007 12:53:23 -0400
X-MimeOLE: Produced By Microsoft Exchange V6.5
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="US-ASCII"
Content-Transfer-Encoding: quoted-printable
Subject: RE: Large multi-record insert performance
Date: Fri, 16 Mar 2007 10:53:10 -0600
Message-ID: <A995A815368F9F40B355EF0046359ABD177A7F@xmbco501.northgrum.com>
In-Reply-To: <x1o3slc5uou2.fsf@sun.com>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: Large multi-record insert performance
Thread-Index: Acdn6YSNW8ZS1roCSgOk4zxSdYKIlAAAIiTw
References: <A995A815368F9F40B355EF0046359ABD177A75@xmbco501.northgrum.com>
 <002f01c76662$c255cea0$dd00a8c0@itsdev.infotechsoft.com>
 <A995A815368F9F40B355EF0046359ABD177A77@xmbco501.northgrum.com>
 <45F8763B.1090707@sbcglobal.net>
 <361C800F-8BC2-48F5-869C-1F0D16FB2C3A@yahoo.com>
 <2B5E40D5B33F4B2B8465EF3E6757270A@Monolith>
 <A995A815368F9F40B355EF0046359ABD177A7D@xmbco501.northgrum.com>
 <x1o3wt1hutd0.fsf@sun.com>
 <A995A815368F9F40B355EF0046359ABD177A7E@xmbco501.northgrum.com>
 <x1o3slc5uou2.fsf@sun.com>
From: "Sedillo, Derek \(Mission Systems\)" <Derek.Sedillo@ngc.com>
To: "Derby Discussion" <derby-user@db.apache.org>
X-OriginalArrivalTime: 16 Mar 2007 16:53:23.0275 (UTC)
 FILETIME=[9BD4F9B0:01C767EB]
X-Virus-Checked: Checked by ClamAV on apache.org

Dyre,

I apologize for the confussion.  I wasn't quite sure what Daniel meant
with regards to:

> All in one transaction using executeUpdate():
> 100 tags added in 274ms
> 100 tags removed in 70ms
> 1000 tags added in 299ms
> 1000 tags removed in 250ms
> 10000 tags added in 1605ms
> 10000 tags removed in 1500ms
> 100000 tags added in 14441ms
> 100000 tags removed in 19721ms

In looking again at your proposed solution, this in fact may be what he
was doing.

> PreparedStatement ps =3D
> conn.prepareStatement("insert into T values (?, ?, ?)");

>  conn.setAutoCommit(false);
>  for (int i =3D 0; i < 1000; ++i) {
      ps.setX(1, <whatever>);
      ps.setX(2, <whatever>);=20
      ps.setX(3, <whatever>);
      ps.executeUpdate();
>  }
>  conn.commit();=20

With autoCommit off you are executing 1000 updates but only performing
'One' commit.  If Daniel is equating transactions with commits then your
approach would be correct.=20

Thank you,

Derek