Re: JAVA vs PERL : PERL wins to postgreSQL

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 much faster with
autocommit off.

Actually I just did a quick test of the two changes I mentioned above.
The first (vacuum) doesn't make any noticable difference, however
turning autocommit off causes the timings on my machine to go from 14
seconds to 6 seconds. Better than 50% improvement.

thanks,
--Barry

andy wrote:
> 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 built for i386-linux.
> The PostgreSQL driver for perl came from www.perl.org
> The postgreSQL driver in jdbc7.0-1.2.jar
>
>
> Barry Lind wrote:
>
>
>>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 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
>>>
>>>
>>>
>>>
>>>------------------------------------------------------------------------
>>>
>>>/*
>>> Java bench mark against perl count to 100 000 000
>>>*/
>>>import java.io.*;
>>>import java.util.*;
>>>
>>>public class lp{
>>>
>>> public lp() throws ClassNotFoundException, FileNotFoundException, IOException
>>> {
>>> int last = 1000;
>>>
>>> GregorianCalendar day = new GregorianCalendar();
>>> String time = day.getTime().toString();
>>> int k=0;
>>> for (int i=0; i<last ; i++) {
>>> for (int p=0; p<last ; p++) {k=1+p;System.out.println(k);}
>>> }
>>>
>>> GregorianCalendar day1 = new GregorianCalendar();
>>> String time2 = day1.getTime().toString();
>>> System.out.println(time);
>>> System.out.println(time2 + "\n" + k);
>>>
>>>
>>> }
>>>
>>>public static void main(String[] args) {
>>> try {
>>> lp test = new lp();
>>> }
>>> catch (Exception ex) {
>>> System.err.println("Exception :" + ex);
>>> ex.printStackTrace();
>>> }
>>>}
>>>}
>>>
>>>
>>>
>>>------------------------------------------------------------------------
>>>
>>>/*
>>> Java equivalent
>>>*/
>>>import java.io.*;
>>>import java.sql.*;
>>>import java.util.*;
>>>
>>>public class pg{
>>> Connection conn;
>>> Statement stmt;
>>>
>>> public pg() throws ClassNotFoundException, FileNotFoundException, IOException, SQLException
>>> {
>>> Class.forName("org.postgresql.Driver");
>>> conn = DriverManager.getConnection("jdbc:postgresql:exkom", "andy", "");
>>> conn.setAutoCommit(true);
>>> stmt = conn.createStatement();
>>> int last = 10000;
>>> int res = stmt.executeUpdate("delete from junk");
>>>
>>> GregorianCalendar day = new GregorianCalendar();
>>> String time = day.getTime().toString();
>>>
>>> for (int i=0; i<last ; i++) {
>>> // try {
>>> res = stmt.executeUpdate("insert into junk values(" + i + ")");
>>>
>>> // } catch (SQLException e) {
>>> // System.out.println(e);
>>> // }
>>> }
>>>
>>> GregorianCalendar day1 = new GregorianCalendar();
>>> String time2 = day1.getTime().toString();
>>>// String time3 = day.getTime().toString();
>>> System.out.println(time);
>>> System.out.println(time2);
>>>// System.out.println(time3);
>>>
>>>// res.close();
>>> stmt.close();
>>> conn.close();
>>>
>>>
>>> }
>>>
>>>public static void main(String[] args) {
>>> try {
>>> pg test = new pg();
>>> }
>>> catch (Exception ex) {
>>> System.err.println("Exception :" + ex);
>>> ex.printStackTrace();
>>> }
>>>}
>>>}
>>>
>>>/**
>>>
>>>
>>>$conn = Pg::connectdb("dbname=exkom");
>>>die $conn->errorMessage unless PGRES_CONNECTION_OK eq $conn->status;
>>>
>>># print "Enter a state code :";
>>># $state_code = <STDIN>;
>>>
>>># chomp $state_code;
>>>$result = $conn->exec("delete from junk");
>>>$end = 10000;
>>>
>>>$t0 = new Benchmark;
>>>
>>>for ($i=1; $i < $end; $i++) {
>>> $result = $conn->exec("insert into junk values($i)");
>>>}
>>>
>>>$t1 = new Benchmark;
>>>$td = timediff($t1, $t0);
>>>print " the $end records took :", timestr($td) , "\n"
>>>**/
>>>
>>>
>>>------------------------------------------------------------------------
>>>
>>>
>>>---------------------------(end of broadcast)---------------------------
>>>TIP 3: if posting/reading through Usenet, please send an appropriate
>>>subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
>>>message can get through to the mailing list cleanly
>>>
>>> lp.java
>>>
>>> Content-Type:
>>>
>>> text/plain
>>> Content-Encoding:
>>>
>>> 7bit
>>>
>>>
>>> ------------------------------------------------------------------------
>>> lp.pl
>>>
>>> Content-Type:
>>>
>>> application/x-perl
>>> Content-Encoding:
>>>
>>> 7bit
>>>
>>>
>>> ------------------------------------------------------------------------
>>> pg.java
>>>
>>> Content-Type:
>>>
>>> text/plain
>>> Content-Encoding:
>>>
>>> 7bit
>>>
>>>
>>> ------------------------------------------------------------------------
>>> pg.pl
>>>
>>> Content-Type:
>>>
>>> application/x-perl
>>> Content-Encoding:
>>>
>>> 7bit
>>>
>>>
>>> ------------------------------------------------------------------------
>>> Part 1.6
>>>
>>> Content-Type:
>>>
>>> text/plain
>>> Content-Encoding:
>>>
>>> binary
>>>
>>>