Just making sure my post got processed. I replied to the join confirmation
after sending my first post. Sorry for the potential redundancy.

Bret

-----Original Message-----
From: Bret Ewin [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 11, 2002 5: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

Reply via email to