[Dbix-class] how do resultsets actually work under the hood?

[Peter Rabbitson]

[5~On Tue, May 28, 2013 at 10:37:41PM +0100, Iain C Docherty wrote:
> 
> So, can anyone give a concise description on how this works
>

I doubt anyone can explain this concisely - the problem field is too 
wide. I would suggest reading the wiki article on Cursors [1], while 
keeping in mind that this is something that happens between the DBD and 
the RDBMS - it is almost always hidden from you. Then keep in mind that 
each RDBMS/DBD combination does things *differently*. And that each DBD 
has different ways of controlling the behavior in question.

DBIC itself does not do much more than what is provided by DBI's 
$sth->fetch(), the wrapper is in ::Storage::DBI::Cursor.

Hope this helps... a little ;)

Cheers

[1] https://en.wikipedia.org/wiki/Cursor_%28databases%29