Maxmix
Member³
Hi,
Day ago I had to insert 40000 records into the table.
Records were short, and they were copy-pasted from Excel. For this, I
1) selected a range in Excel and pressed Ctrl+C (instantly);
2) in PL/SQL Developer, executed in SQL Window an ordinary statement: select t.*, rowid from mytable t
and allowed editing in the result grid;
3) then selected empty cell in the most left column;
4) finally, pressed Ctrl+V;
5) posted changes and committed.
It worked just as did many times before. However, pasting took about 20 minutes
For twenty minutes the application seemed to be hanged. CPU load was at 1%.
I would like to know: why is it so slow?
I have Core i7 CPU and plenty of RAM, and still insertion rate was 30 rows/s... (about 3Kb/s if I estimate correctly)
If the process SHOULD be so long, then could we have some progress meter, please?
Day ago I had to insert 40000 records into the table.
Records were short, and they were copy-pasted from Excel. For this, I
1) selected a range in Excel and pressed Ctrl+C (instantly);
2) in PL/SQL Developer, executed in SQL Window an ordinary statement: select t.*, rowid from mytable t
and allowed editing in the result grid;
3) then selected empty cell in the most left column;
4) finally, pressed Ctrl+V;
5) posted changes and committed.
It worked just as did many times before. However, pasting took about 20 minutes

For twenty minutes the application seemed to be hanged. CPU load was at 1%.
I would like to know: why is it so slow?
I have Core i7 CPU and plenty of RAM, and still insertion rate was 30 rows/s... (about 3Kb/s if I estimate correctly)
If the process SHOULD be so long, then could we have some progress meter, please?