How to prevent jdbc from sending any results back to the client ?

From: Dimitris Karampinas <dkarampin(at)gmail(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: How to prevent jdbc from sending any results back to the client ?
Date: 2014-04-19 18:48:52
Message-ID: CAC_Q3Nx66+5yPF4=8=C2PW7jVNGQ2FegvOQpzAjKsM9uGqh5RA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi,

I'm working on an academic project and I need to benchmark PostgreSQL.
I'm intersted only about the performance of the DBMS itself and I'm trying
to keep things simple in my measurements.
Preferably I'd like to ignore the query results at the client side but jdbc
seems to return results even if I don't call next() on the Resultset (is
that true ?).
As a consequence, I can't measure acurately a per query execution time
since the time I get depends also on the time spent to send the answer (or
part of it) to the client.
setFetchSize(1) doesn't seem to help much.
Can I hack the driver and diminish the overhead explained above ?

Cheers,
Dimitris

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Sehrope Sarkuni 2014-04-19 19:02:12 Re: How to prevent jdbc from sending any results back to the client ?
Previous Message Gavin Flower 2014-04-19 03:33:37 Re: Speed up JDBC connection creation on 9.0+