learnt SQL_BIG_RESULT in the select syntax builds a temporary table on the result (if I'm right). What will the Select statement to access such temporary table look like?
This is an internal temporary table, the result is returned in the normal way, and the temporary table is destroyed.
SQL_BIG_RESULT tells the engine the query result will be big, so the engine will not try to keep everything in memory (normally fastest), it will use a temporary table to solve the query. The result is the same, but without SQL_BIG_RESULT the engine would first try to fit the query in memory, when failing it would build the disk-based temporary table anyway, thus it would take more time.
<URL: http://dev.mysql.com/doc/mysql/en/select.html#id2674115 >
-- Roger
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
