Will using a PreparedStatement only once introduce additional round-trips compared to a simple text-only query? - Mailing list pgsql-jdbc

From Clemens Eisserer
Subject Will using a PreparedStatement only once introduce additional round-trips compared to a simple text-only query?
Date
Msg-id CAFvQSYRaG_TTCrJnkxsoE6NBrKfrvC+OLOrGz1yDjrMYXPgYvg@mail.gmail.com
Whole thread Raw
List pgsql-jdbc
Hi,

When using prepared statements only once, will there be additional
roundtrips required between jdbc-client and postgresql-server in order
to prepare the query? Will there be a lot of additional data
exchanged?

The application I am developing uses Hibernate as middleware which
uses PreparedStatements a lot, however because I ran into a few
problems with PreparedStatement caching I plan to disable caching,
which will lead to quite a few PreparedStatements only used a single
time and recreated each run.

Thank you in advance, Clemens

pgsql-jdbc by date:

Previous
From: Dave Cramer
Date:
Subject: Re: Patch: Add support for building with JDK 8
Next
From: Shijun Kong
Date:
Subject: PGSimpleDataSource not support jdbc url