Re: [GENERAL] Limiting number of rows returned at a time in select query

2007-05-28 Thread Andrew Sullivan
On Thu, May 24, 2007 at 05:32:25AM -0700, Jon Clements wrote: > have a .NET driver that has a FetchSize option which allows the above > (say returning 10k rows at a time without holding them all in memory); > I'm not sure though if that's a property of the driver / server, as > none of the other in

[GENERAL] Limiting number of rows returned at a time in select query

2007-05-28 Thread Jon Clements
Hi All. Is there a way inside a query (or connection) to limit the amount of records returned each chunk by the server? At the moment, I have 22 million records trying to be returned in one-go as the result set. I have a .NET driver that has a FetchSize option which allows the above (say returning

Re: [GENERAL] Limiting number of rows returned at a time in select query

2007-05-24 Thread Rodrigo De León
Jon Clements ha escrito: > Hi All. > > Is there a way inside a query (or connection) to limit the amount of > records returned each chunk by the server? At the moment, I have 22 > million records trying to be returned in one-go as the result set. I > have a .NET driver that has a FetchSize option w