X-Original-To: pgsql-jdbc@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 0AD7647580B for ; Sun, 16 Feb 2003 18:23:27 -0500 (EST) Received: from fep03-mail.bloor.is.net.cable.rogers.com (fep03-mail.bloor.is.net.cable.rogers.com [66.185.86.73]) by postgresql.org (Postfix) with ESMTP id 5CBAC475461 for ; Sun, 16 Feb 2003 18:23:26 -0500 (EST) Received: from spook ([65.48.10.226]) by fep03-mail.bloor.is.net.cable.rogers.com (InterMail vM.5.01.05.06 201-253-122-126-106-20020509) with ESMTP id <20030216232302.XGKI360645.fep03-mail.bloor.is.net.cable.rogers.com@spook> for ; Sun, 16 Feb 2003 18:23:02 -0500 Message-ID: <000e01c2d612$66b29450$6401a8c0@spook> From: "John Cavacas" To: References: <5.2.0.9.0.20030216232710.01b40810@mail.polonium.de> Subject: Re: Good performance? Date: Sun, 16 Feb 2003 18:23:23 -0500 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2720.3000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Authentication-Info: Submitted using SMTP AUTH LOGIN at fep03-mail.bloor.is.net.cable.rogers.com from [65.48.10.226] using ID at Sun, 16 Feb 2003 18:23:02 -0500 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/237 X-Sequence-Number: 6408 > .... > pstmt.setLong(1, getUniquelongID()); >.... What is getUniquelongID()? Can you post the code for that? I would suspect that might be your problem. Your results point to something being wrong somewhere. Just yesterday I was doing some benchmarking of my own, and using code similar to yours I was inserting 10000 records in about 23 seconds. john