Re: Slow response from 'SELECT * FROM table'

On Mon, Nov 11, 2002 at 12:19:47PM -0500, Wei Weng wrote:
> I am curious, what performance difference does it make to use vanilla
> SELECT with to use cursor (for retrieving the entire records)?

If you use a cursor, you don't need to buffer the entire record set
before returning it.

A
--
----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110