Is the database query faster if I insert multiple rows at once: like INSERT.... UNION INSERT.... UNION (I need to insert like 2-3000 rows)

Inserting multiple rows in mysql

Created Jul 31, 2011 Edited Jul 31, 2011

Viewed 910877

Is the database query faster if I insert multiple rows at once:

INSERT....

UNION

INSERT....

UNION

(I need to insert like 2-3000 rows)

sql-insert mysql