Re: Getting ResultSet From Cursor Too Slow

what's the most important to you, the time to get
the result set, or the time it takes to process
the result set? If the former, don't set the fetch size,
and if the latter, set it to as many rows as you
expect. However, there's probably nothing much
you can do to make the DBMS faster when it is
sending you the data you ask for. Do try the very
latest 10G driver. It is faster than any previous.

Joe Weinstein at BEA

.