Multi Insert vs insert into Select I have about 2000 rows to be inserted at a time. Which is Optimized method Multiinsert or insert into .. SEelec colum1, column2 from table .
In case if Multi-insert, I will SELECT generate multiple statments in my application.
So in short, which is Optimized?
INSERT INTO table_name(column_list)
SELECT 
   select_list 
FROM 
   another_table
WHERE
   condition;

OR
INSERT INTO table(c1,c2,...)
VALUES 
   (v11,v12,...),
   (v21,v22,...),
    ...
   (vnn,vn2,...);
For only 2,000 records, one INSERT will be most performant. Inserting batches of records is generally the best way to do it (with batch sizes up to as much as roughly 100,000 typically). It shouldn't matter if you use VALUE syntax or SELECT query syntax, as long as they're in the same batch.
This article does a good job going in depth on additional INSERT optimization techniques.