Even though limit is reached, maxrows continues to buffer resultset.

maxrows has to buffer data until the limit has been reached or the entire result set has been received.

However, when the limit has been reached, maxrows need not buffer data anymore but can free the packets as they arrive from the server.