Skip site navigation (1) Skip section navigation (2)

Performance issue with JDBC

From: Ken Kachnowich <khkachn(at)toad(dot)net>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: Performance issue with JDBC
Date: 2000-09-06 22:04:25
Message-ID: 39B6BF69.E1AC723F@toad.net (view raw or flat)
Thread:
Lists: pgsql-interfaces
Hi,

  I am testing a Java application with the PostgreSQL JDBC that inserts
a bunch of
records into a database. Inserting 15 - 20 records every 10 seconds I
find that
the JDBC or Postgres can not keep up so I have a couple of questions.

1) Where can I get the latest and greatest code for the JDBC? I
downloaded
    the 7.0.2 PostgreSQL release and have been using the JDBC included
there.
    Have there been any patches since that may help performaance?

2) One of the fields inserted is a serialized Java object. I am saving
it as a large
    object right now because I could not figure out how to get anything
else to
    work. Could this be slowing things down? Is there a better way, such
as
    into a bytea or varchar? Also where might I find some sample code to
show
    me how to do it?

3) Any other performance tips that may help me?

Thanks,

Ken K


Responses

pgsql-interfaces by date

Next:From: Mark DzmuraDate: 2000-09-07 02:41:20
Subject: getting back "rowid" after an insert...
Previous:From: Alec SmecherDate: 2000-09-06 20:01:33
Subject: JDBC Insert row?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group