When rows of a resultset are generated?
If MySQL needs to create a temporary table it generates the result before sending it to a client. 

Normally you want to avoid that and make Mysql to generate the result as it accesses the table(s) and as fast as the client reads it.