Re: statement caching proof of concept

Till,

Thanks, this is a great example. So how would any caching
implementation deal with this?

I can think of copying the result set into the wrapper, but that
could be prohibitively expensive.

Dave
On 19-Jun-06, at 7:56 PM, till toenges wrote:

> Dave Cramer wrote:
>> AFAIK Postgres doesn't allow concurrent statements on the same
>> connection, so I don't see how using multiple threads would work ?
>
> The statements wouldn't need to be concurrent in the sense of
> happening
> at the same time:
>
> // stupid query
> String sql = "SELECT * FROM quicklychangingtable";
> PreparedStatement p1 = connection.prepareStatement(sql);
> PreparedStatement p2 = connection.prepareStatement(sql);
> ResultSet r1 = p1.executeQuery();
> // do something else for a while
> ResultSet r2 = p2.executeQuery();
>
> What happens with r1? Might be ok, but i'm not sure if this is
> always true.
>
>
> Till
>