From: | Peter Mount <petermount(at)maidstone(dot)gov(dot)uk> |
---|---|
To: | "'khkachn(at)NOSPAMtoad(dot)net'" <khkachn(at)toad(dot)net>, pgsql-interfaces(at)postgresql(dot)org |
Subject: | RE: Performance issue with JDBC |
Date: | 2000-09-11 10:35:38 |
Message-ID: | 1B3D5E532D18D311861A00600865478CF1B395@exchange1.nt.maidstone.gov.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
There are some performance related patches, which I've applied at home
(should hopefully be uploading them later tonight).
As for serializing objects, there is a non-standard extension, but unless
your lo's are large then that shouldn't be affecting it.
There are examples in the source.
Peter
--
Peter Mount
Enterprise Support Officer, Maidstone Borough Council
Email: petermount(at)maidstone(dot)gov(dot)uk
WWW: http://www.maidstone.gov.uk
All views expressed within this email are not the views of Maidstone Borough
Council
-----Original Message-----
From: Ken Kachnowich [mailto:khkachn(at)toad(dot)net]
Sent: Wednesday, September 06, 2000 11:04 PM
To: pgsql-interfaces(at)postgresql(dot)org
Subject: [INTERFACES] Performance issue with JDBC
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
From | Date | Subject | |
---|---|---|---|
Next Message | Zeljko Trogrlic | 2000-09-11 10:56:23 | Re: Performance issue with JDBC |
Previous Message | Zeljko Trogrlic | 2000-09-11 10:18:45 | RE: JDBC and Unicode problem |