Re: [JDBC] JAVA vs PERL : PERL wins to postgreSQL

2001-09-05 Thread Kovács Péter
; -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

Re: [JDBC] JAVA vs PERL : PERL wins to postgreSQL

2001-09-04 Thread Barry Lind
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

Re: [JDBC] JAVA vs PERL : PERL wins to postgreSQL

2001-09-04 Thread andy
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

Re: [JDBC] JAVA vs PERL : PERL wins to postgreSQL

2001-09-03 Thread Barry Lind
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

Re: [JDBC] JAVA vs PERL : PERL wins to postgreSQL

2001-09-03 Thread Robert J. Sanford, Jr.
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

Re: [JDBC] JAVA vs PERL : PERL wins to postgreSQL

2001-09-03 Thread Anders Bengtsson
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

Re: [JDBC] JAVA vs PERL : PERL wins to postgreSQL

2001-09-03 Thread Rene Pijlman
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

Re: [JDBC] JAVA vs PERL : PERL wins to postgreSQL

2001-09-03 Thread Joe Shevland
> 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

[JDBC] JAVA vs PERL : PERL wins to postgreSQL

2001-09-03 Thread andy
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