the
> initial query. I tried Statement.setFetchSize() but that doesn't appear to
> help. Any suggestions in this area?
>
> Thanks,
> Bret
>
> -Original Message-
> From: James Montebello [mailto:[EMAIL PROTECTED]]
> Sent: Friday, January 11, 2002 5:57 PM
> To: Bret Ewin
ppear to
help. Any suggestions in this area?
Thanks,
Bret
-Original Message-
From: James Montebello [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 11, 2002 5:57 PM
To: Bret Ewin
Cc: [EMAIL PROTECTED]
Subject: Re: returning partial result set
If all you want is the first page, then simpl
PROTECTED]
Subject: returning partial result set
My system tends to generate large result sets, with the first page of
results being used and the rest thrown away. I expect this is typical in
other systems as well. I've noticed the JDBC driver retrieves the entire
result set before lettin
If all you want is the first page, then simply use SELECT ... LIMIT n,
which will only return the first n rows of the set. To "page through"
data, use LIMIT offset, n, which will return n rows starting at offset
rows into the dataset. Note that doing this on a changing table will
give results t
partial result set
My system tends to generate large result sets, with the first page of
results being used and the rest thrown away. I expect this is typical in
other systems as well. I've noticed the JDBC driver retrieves the entire
result set before letting the application iterate ove
My system tends to generate large result sets, with the first page of
results being used and the rest thrown away. I expect this is typical in
other systems as well. I've noticed the JDBC driver retrieves the entire
result set before letting the application iterate over any results. I'm not
sure
