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
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
the 7.0.2 PostgreSQL release and have been using the JDBC included
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
work. Could this be slowing things down? Is there a better way, such
into a bytea or varchar? Also where might I find some sample code to
me how to do it?
3) Any other performance tips that may help me?
pgsql-interfaces by date
|Next:||From: Mark Dzmura||Date: 2000-09-07 02:41:20|
|Subject: getting back "rowid" after an insert...|
|Previous:||From: Alec Smecher||Date: 2000-09-06 20:01:33|
|Subject: JDBC Insert row?|