Re: JAVA vs PERL : PERL wins to postgreSQL

i have several questions about the benchmark run that all come
down to one basic question - was the benchmark fair?

1) were you trying to test the performance of the languages or
were you trying to test the performance of the drivers? if
you are trying to test _languages_ then what you should do
is to use a common driver. if you are coding on a windoze
platform you can set up the odbc driver and have both perl
and java connect to the db through the same driver. i don't
know how 'fair' that test is though because java will still
have the overhead of jdbc:odbc bridge.

2) assuming that you are trying to test differences in drivers,
what did the tests consist of? were the insertions done in
the context of a transaction or outside of one? a test that
i ran that inserted 250+ records in one table and then 4500
in another test through perl and odbc ran at about 1:25 out
of a transaction and 0:30 inside of a transaction. there's
a big difference.

3) did both of the drivers used have the same settings? did
you make sure that the autocommit states were identical?

4) did you take into account ONLY the amount of time needed to
insert the data or were the times listed for assembling,
inserting, and reporting results?

5) did you do a "warm up" session so that the code was in the
same state as if it had been running on the server or were
both run from cold starts? would that make a difference in
terms of loading up all the drivers, etc.?

6) did the benchmark only use one connection for the entire
test or were multiple connections used? if multiple, did
you optimize your code like you would for a production
setting where you would be using connection pooling?

rjsjr

> -----Original Message-----
> From: pgsql-jdbc-owner(at)postgresql(dot)org
> [mailto:pgsql-jdbc-owner(at)postgresql(dot)org]On Behalf Of andy
> Sent: Monday, September 03, 2001 12:47 AM
> To: pgsql-jdbc(at)postgresql(dot)org
> Subject: [JDBC] JAVA vs PERL : PERL wins to postgreSQL
>
>
> 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
> screen and not to a table,
>
> JAVA took 3 seconds and PERL 310 Seconds.
> My conclusion is that the database driver to postgreSQL is still far
> from efficient in the JAVA implementation.
>
> Both tests were run on the same computer.
>
> I would appreciate your comments and suggestions.
> Andy Sewell
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>