[eluser]TheJim[/eluser]
Well, as you might have guessed, I'm a little partial to get_streaming, but I think get_iterated and get_for_looping aren't bad either.
As for it helping with smaller result sets as well, I believe it's mostly that the DataMapper constructor is a little heavy -- which makes perfect sense for the "magic" provided. I have a couple of ideas for further improving that, hopefully without complicating things too much, but it would probably be more involved than the enhancements I did suggest, and I haven't gotten around to writing the code and checking if my ideas will even work. Of course, even with a faster constructor, there would still be memory savings to the iterator/streaming approach, but less of a CPU savings.
Anyway, I'm rambling. I need to check out 1.7 and see what other goodies you've managed to fit in. Thanks for the hard work, Phil.