Hello and thanks for your answer! If I have understood correctly LIMIT will only return as many row as the limit. I need all rows, but I can't handle them all at once. In JDBC there are a method to "stream" the resultset into small portions and when the end of the portion is reached it automatically gets the next portion.
Thanks roland Carlsson ----- Original Message ----- From: "Rusch (ext) Reiner" <[EMAIL PROTECTED]> To: "'Roland Carlsson'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, March 11, 2003 12:59 PM Subject: AW: Large resultset > Hi, > > why don't you try to solve the problem with ordinary sql-selects. > You can take "select ..... limit ...." > > regards > Reiner > > > -----Ursprüngliche Nachricht----- > > Von: Roland Carlsson [mailto:[EMAIL PROTECTED] > > Gesendet: Dienstag, 11. März 2003 12:54 > > An: [EMAIL PROTECTED] > > Betreff: Large resultset > > > > > > Hi! > > I have a query that returns a resultset of 70 mb. I'd somehow > > would like > > J/Connector to fetch only small pieces using > > Statement.setFetchSize but it > > still get the whole ResultSet at once and then I get an > > OutOfMemoryError. > > > > Is it a bug in setFetchSize? Does J/Connector ignore it? Have > > I totally > > missunderstood what setFetchSize does? > > > > I use J/Connector 3.0.6 > > > > Regards > > Roland Carlsson > > > > > > --------------------------------------------------------------------- > > Before posting, please check: > > http://www.mysql.com/manual.php (the manual) > > http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail > > <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
