How to speed up insertion of 10,000 records into a table
470287Dec 22 2005 — edited Dec 26 2005Hi,
I have one table with 40 fields in which have several not null, 6/7 randomly generated (through trigger) fields and 8/9 indexes including pk and uk. Now i have to insert 10,000 records at a time through a procedure using loop. But it takes time => 00:01:05.25. I need the task within 2/3sec. Can anyone help me in this regard urgently ....