Re: Pass column name in preparedstatement - Mailing list pgsql-jdbc

From Thomas Hallgren
Subject Re: Pass column name in preparedstatement
Date
Msg-id thhal-0JoPtAlt3xiccbsTO5Ds7AdAazZA/TY@mailblocks.com
Whole thread Raw
In response to Re: Pass column name in preparedstatement  (Antony Paul <antonypaul24@gmail.com>)
List pgsql-jdbc
Antony Paul wrote:
> In 7.3.3 is there any use in using PreparedStatement since the columns
> may change for each query.
>
Depends on the use case. I created a solution a while back where I used
a MRU cache to hold the 10 or so most frequently generated
PreparedStatements. In my case that improved performance a whole lot.
This was not a PostgreSQL database though but I guess the effect could
be similar.

Regards,
Thomas Hallgren


pgsql-jdbc by date:

Previous
From: Antony Paul
Date:
Subject: Re: Pass column name in preparedstatement
Next
From: mmckenzie@unmc.edu
Date:
Subject: Which driver should I use?