X-Original-To: pgsql-jdbc@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 537E8475921 for ; Sun, 16 Feb 2003 19:23:52 -0500 (EST) Received: from trill.maridan.net (unknown [217.6.52.210]) by postgresql.org (Postfix) with ESMTP id 5B5624758BD for ; Sun, 16 Feb 2003 19:23:50 -0500 (EST) Received: from rafcio.polonium.de (130-149-145-109.dialup.cs.tu-berlin.de [130.149.145.109]) by trill.maridan.net (8.9.3/8.9.3) with ESMTP id BAA23379 for ; Mon, 17 Feb 2003 01:23:48 +0100 Message-Id: <5.2.0.9.0.20030217012205.01c43398@mail.polonium.de> X-Sender: rafcio@mail.polonium.de X-Mailer: QUALCOMM Windows Eudora Version 5.2.0.9 Date: Mon, 17 Feb 2003 01:23:45 +0100 To: From: Rafal Kedziorski Subject: Re: Good performance? In-Reply-To: <000e01c2d612$66b29450$6401a8c0@spook> References: <5.2.0.9.0.20030216232710.01b40810@mail.polonium.de> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/238 X-Sequence-Number: 6409 At 18:23 16.02.2003 -0500, John Cavacas wrote: > > .... > > pstmt.setLong(1, getUniquelongID()); > >.... > >What is getUniquelongID()? Can you post the code for that? I would >suspect that might be your problem. here is the code. private final static long getUniquelongID() { return (System.currentTimeMillis() * 1000 + (long) (100000 * Math.random())); } but this routine is very fast. for computing 100.000 values she need 6-7 seconds. >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 > > >---------------------------(end of broadcast)--------------------------- >TIP 3: if posting/reading through Usenet, please send an appropriate >subscribe-nomail command to majordomo@postgresql.org so that your >message can get through to the mailing list cleanly