On Tue, 14 Sep 2004, Stephen Crowley wrote:

> Problem solved.. I set the fetchSize to a reasonable value instead of
> the default of unlimited  in the PreparedStatement and now the query
> is . After some searching it seeems this is a common problem, would it
> make sense to change the default value to something other than 0 in
> the JDBC driver?

In the JDBC driver, setting the fetch size to a non-zero value means that 
the query will be run using what the frontend/backend protocol calls a 
named statement.  What this means on the backend is that the planner will 
not be able to use the values from the query parameters to generate the 
optimum query plan and must use generic placeholders and create a generic 
plan.  For this reason we have decided not to default to a non-zero 
fetch size.  This is something whose default value could be set by a URL 
parameter if you think that is something that is really required.

Kris Jurka

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Reply via email to