@ WithBridgeMethods ( value = MySQLQuery . class , castRequired = true ) public C bufferResult ( ) { return addFlag ( Position . AFTER_SELECT , SQL_BUFFER_RESULT ) ; }
SQL_BUFFER_RESULT forces the result to be put into a temporary table . This helps MySQL free the table locks early and helps in cases where it takes a long time to send the result set to the client . This option can be used only for top - level SELECT statements not for subqueries or following UNION .