Insert into grid performance

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 :o
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?
 
Perhaps it is caused by the "Refresh posted records" option (Tools > Preferences > SQL Window)? Does it help if you disable it?
 
Back
Top