List:General Discussion« Previous MessageNext Message »
From:dbrb2002-sql Date:September 25 2009 5:08am
Subject:INSERT ... SELECT ON DUPLICATE
View as plain text  
Does anyone know if I can add a hint SQL_BUFFER_RESULT to INSERT .. SELECT ON DUPLICATE

ex..

INSERT INTO foo
SELECT SQL_BUFFER_RESULT* FROM bar
ON DUPLICATE KEY UPDATE foo.X=..

Both my tables foo and bar are InnoDB; but the idea is to release the lock on bar as soon
as possible by moving the results to temp table to accommodate slow inserts..

Any reco or does SQL_BUFFER_RESULT work in this case ?

Thanks





Thread
INSERT ... SELECT ON DUPLICATEdbrb2002-sql25 Sep