5000 inserts into 2 long tables

Dúvidas, dicas e truques de SQL, Select, Update, Delete, cláusulas, operações com joins, Funções em SQLs, etc
  

Poston 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

Poston 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! :-o
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

Who is online

Users browsing this forum: No registered users and 2 guests