You could, and actually most of the needed code is already in place due to the feature of scrolling collection fetches. The main problem there is that it *only* works (in terms of what you are trying to achieve) provided you know for certain that the results are ordered correctly (namely, they must be ordered by the owning entity primarily such that all possible rows for a given owner are contiguous within the result set). And what about polymorphic queries?
The cleanest solution is to fall back to subselect fetching in these cases; which, of course, has its own implementation difficulties. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Emmanuel Bernard Sent: Tuesday, February 28, 2006 7:12 PM To: Hibernate development Subject: [Hibernate] setfirstResult() / setMaxResult() and collection fetching Wouldn't it be possible to implement that through a scrollable resultset when a collection fetch is involved. This would limit the amount of data in memory. ------------------------------------------------------- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 _______________________________________________ hibernate-devel mailing list hibernate-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hibernate-devel ------------------------------------------------------- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid0944&bid$1720&dat1642 _______________________________________________ hibernate-devel mailing list hibernate-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hibernate-devel