Re: Large # of rows in query extremely slow, not using

On Thu, 23 Sep 2004, Stephen Crowley wrote:

> Thanks for the explanation. So what sort of changes need to be made to
> the client/server protocol to fix this problem?

The problem is that there is no way to indicate why you are using a
particular statement in the extended query protocol. For the JDBC driver
there are two potential reasons, streaming a ResultSet and using a server
prepared statement. For the streaming as default case you desire there
needs to be a way to indicate that you don't want to create a generic
server prepared statement and that this query is really just for one time
use, so it can generate the best plan possible.

Additionally you can only stream ResultSets that are of type FORWARD_ONLY.
It would also be nice to be able to specify scrollability and holdability
when creating a statement and the offset/direction when streaming data
from a scrollable one.

Kris Jurka