Re: statement caching proof of concept

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