From: Doug McNaught <doug@wireboard.com>
To: John Oakes <john@networkproductions.net>
Cc: pgsql-general@postgresql.org
Subject: Re: JDBC speed question.
Date: 26 Apr 2001 18:35:39 -0400
Message-ID: <m3pudzuw5g.fsf@belphigor.mcnaught.org> (raw)
References: <wCiF6.88303$fs3.14153563@typhoon.tampabay.rr.com>
"John Oakes" <john@networkproductions.net> writes:
> Anyone have any ideas how to speed up performance using the JDBC driver? A
> query that takes me 20 seconds to execute from command line takes 1 full
> minute with the jdbc driver. Thanks.
Since you don't guve any details of your query or network setup, it's
hard to help much. What could account for the difference, assuming
that the query is exactly the same in both cases, is that the JDBC
driver connects through TCP/IP (even when on the same host) whereas
'psql' will by default connect through a Unix socket. On most
systems, Unix sockets are considerably faster than even local TCP
sockets. If the JDBC client is running on a different machine, the
difference becomes even more pronounced.
This is assuming that your query is returning a great deal of data, so
the network pipe is a factor in the execution time. If it isn't, then
it's unclear how to help you without more details on your table
layouts and the query itself.
-Doug
--
The rain man gave me two cures; he said jump right in,
The first was Texas medicine--the second was just railroad gin,
And like a fool I mixed them, and it strangled up my mind,
Now people just get uglier, and I got no sense of time... --Dylan
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: doug@wireboard.com, john@networkproductions.net, pgsql-general@postgresql.org
Subject: Re: JDBC speed question.
In-Reply-To: <m3pudzuw5g.fsf@belphigor.mcnaught.org>
References: <wCiF6.88303$fs3.14153563@typhoon.tampabay.rr.com> <m3pudzuw5g.fsf@belphigor.mcnaught.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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