I have a load of data which consists of only 2 columns as 50000 rows in MS Excel. I created an insert query using some concat() functions and got a list of insert queries (additional info in file:
insert into X_Table (Id, NewId)
values (14878, 1000009442)
However, when I try to run the insert statements, it inserts only 50-60 rows per minute, which I would argue is extremely slow.
Note that there is no single index, column or any sort of handicap in the table.
Which steps should I take to analyze why this happens? Or if have any direct answer, which you may have already encountered, please, let me know the solution.
1条答案
按热度按时间yyyllmsg1#
It took seconds to insert all the rows on my local PC.
In the c column of the Excel sheet, I have written this formula:
I got these SQL statements:
All 50'000 rows have been inserted within 6 seconds. Please try this.