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