Dúvidas, dicas e truques de SQL, Select, Update, Delete, cláusulas, operações com joins, Funções em SQLs, etc
on Thu, 24 Jun 2004 4:27 pm
Hello Bank Environment: Oracle 8.1.7 Linux RedHat 7.3 Pentium III 500 MHz, 1 GB memory Have an array in memory containing information to make 5000 inserts in 2 tables. I'm scanning the array and inserting each row in the tables 2. The commit will come after the end of the inserts.
My problem: is taking over an hour and still not finish. What can I do to improve this?
[] s Luca
-
Luca
- Location: Sao Paulo / SP
on Thu, 24 Jun 2004 8:52 pm
The problem is even in inserts?
I tried to comment on just the inserts and run your program to see if it takes hours too?
And the problem is really the INSERT as well .... How many rows have this table? Have indexes? Has triggers? Send us this information!

-
dr_gori
- Location: Portland, OR USA
Thomas F. G
Você já respondeu a dúvida de alguém hoje?
http://glufke.net/oracle/search.php?search_id=unanswered
-
Return to SQL
Users browsing this forum: No registered users and 2 guests