pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedPerformance issue with JDBC
3+ messages / 3 participants
[nested] [flat]
* Performance issue with JDBC
@ 2000-09-06 22:04 Ken Kachnowich <khkachn@toad.net>
0 siblings, 1 reply; 3+ messages in thread
From: Ken Kachnowich @ 2000-09-06 22:04 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 3+ messages in thread
* RE: Performance issue with JDBC
@ 2000-09-11 10:35 Peter Mount <petermount@maidstone.gov.uk>
0 siblings, 0 replies; 3+ messages in thread
From: Peter Mount @ 2000-09-11 10:35 UTC (permalink / raw)
To: 'khkachn@NOSPAMtoad.net' <khkachn@toad.net>; 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@maidstone.gov.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@toad.net]
Sent: Wednesday, September 06, 2000 11:04 PM
To: pgsql-interfaces@postgresql.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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Performance issue with JDBC
@ 2000-09-11 10:56 Zeljko Trogrlic <zeljko@technologist.com>
parent: Ken Kachnowich <khkachn@toad.net>
0 siblings, 0 replies; 3+ messages in thread
From: Zeljko Trogrlic @ 2000-09-11 10:56 UTC (permalink / raw)
To: khkachn@NOSPAMtoad.net; pgsql-interfaces
There is a "Fastpath" extension made for large objects. Try that.
At 00:04 7.9.2000 , Ken Kachnowich wrote:
>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
>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2000-09-11 10:56 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-09-06 22:04 Performance issue with JDBC Ken Kachnowich <khkachn@toad.net>
2000-09-11 10:56 ` Zeljko Trogrlic <zeljko@technologist.com>
2000-09-11 10:35 RE: Performance issue with JDBC Peter Mount <petermount@maidstone.gov.uk>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox