sql-generate-insert icon indicating copy to clipboard operation
sql-generate-insert copied to clipboard
verified publisher icon drumsta

Use UNION ALL instead of UNION in output SQL script

Open i4rilu opened this issue 7 years ago • 0 comments

UNION ALL is much much much faster in such mass-inserts. With 19K INSERTs the performance was 2hrs vs 2 min.

i4rilu avatar Dec 20 '18 11:12 i4rilu