SQL_BIG_RESULT and performance?

[Mark Modrall]

Hi...

I was looking at the doc page for 4.1 and see the SQL_BIG_RESULT, SQL_BUFFER_RESULT, and SQL_SMALL_RESULT options for SELECT statements, but it's not clear what the performance implications are. For that matter "BIG" and "SMALL" are left completely unscoped...

In one of my applications, I'm regularly making selects with group bys resulting in 300K+ rows and then reading them. Would that be considered large?

What would I expect to see in terms of performance impact for adding SQL_BIG_RESULT or SQL_BUFFER_RESULT to that query? I'm using ORDER BY NULL so there isn't sorting going on.

Thanks
_mark