Performance between CREATE TEMP TABLE AS vs INSERT INTO SELECT

Vote count:

0

I was wondering is there a performance difference between:

query 1: CREATE TEMPORARY TABLE temp_table1 AS SELECT * FROM lookup_table JOIN ...

vs

query 2: INSERT INTO real_table SELECT * FROM lookup_table JOIN ... 

My concern was, the lookup_table is accessed very often by different users and when I run query 2, most of the users need to wait longer to be able to retrieve their result. What I was thinking was to write the data into a temporary table then write it to a real table afterwards . Im just not sure if writing into a temp table with give a difference performance compared to writing it directly to the destination table. Im using mysql 5.6.

asked 42 secs ago

John

235