; -Original Message-
> From: Barry Lind [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, September 04, 2001 6:49 PM
> To: andy
> Cc: [EMAIL PROTECTED]
> Subject: Re: [JDBC] JAVA vs PERL : PERL wins to postgreSQL
>
>
> Andy,
>
> Thanks for the code. In looking at this there
Andy,
Thanks for the code. In looking at this there are two things that come
to mind:
1) You probably should be running vacuum after the delete to clean up
the table, but on a table this small, I doubt it will make any real
difference.
2) Why have you set autocommit on? This should be mu
To all those who responded ,
Thanks for your response,
I have attached the test programs that I used in the form of text files. The
contents should be self evident. Please have a look and comment.
I used j2sdk1.3.1 down load to linux machine from sun.com as my java platform
and
And perl, v5.6.0
Andy,
I would be interesting in knowing what version you did this test on,
what platform, and most importantly which JDK (and if the Sun JDK which
JVM: classic, hotspot client, hotspot server).
thanks,
--Barry
andy wrote:
> Hi,
>
> I ran a few bench marks on JAVA writing to a postgreSQL tabl
ginal Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of andy
> Sent: Monday, September 03, 2001 12:47 AM
> To: [EMAIL PROTECTED]
> Subject: [JDBC] JAVA vs PERL : PERL wins to postgreSQL
>
>
> Hi,
>
> I ran a few bench marks on JAVA writi
On Mon, 3 Sep 2001, andy wrote:
> Hi,
>
> I ran a few bench marks on JAVA writing to a postgreSQL table using and
> found that for the same number of records added to the table as a
> similar PERL routine the following results :
> PERL 39 seconds : JAVA 45 Seconds.
How did you start the te
On Mon, 03 Sep 2001 07:47:29 +0200, you wrote:
>I ran a few bench marks on JAVA writing to a postgreSQL table using and
>found that for the same number of records added to the table as a
>similar PERL routine the following results :
> PERL 39 seconds : JAVA 45 Seconds.
>In a similar experimen
> I ran a few bench marks on JAVA writing to a postgreSQL table
> using and
> found that for the same number of records added to the table as a
> similar PERL routine the following results :
> PERL 39 seconds : JAVA 45 Seconds.
> In a similar experiment where PERL and JAVA did treir output t
Hi,
I ran a few bench marks on JAVA writing to a postgreSQL table using and
found that for the same number of records added to the table as a
similar PERL routine the following results :
PERL 39 seconds : JAVA 45 Seconds.
In a similar experiment where PERL and JAVA did treir output to the
s