In your select statement, use the LIMIT option SELECT * FROM table limit 10;
will return the first ten rows, or SELECT * FROM table limit 100,10 will return rows 101-110 -----Original Message----- From: Bret Ewin [mailto:[EMAIL PROTECTED]] Sent: Friday, January 11, 2002 4:47 PM To: [EMAIL 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 letting the application iterate over any results. I'm not sure if this is a limitation in the database or the driver. Oracle has the capability to start returning results as they are generated. Does MySQL have something similar? If not, is there anything I can do to alleviate this behavior? Thanks, Bret --------------------------------------------------------------------- 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