im taking a long period of time to do SQL insertion.
basically it takes ard 4ms for a record insert. Using query analyzer, i used a for loop and insert into a table 10000 times. the result 42 secs. I need to shorten this time taken as im doing some simulation work and real time analysis.
I am using scope_ident() to grab the primary key of a table and insert this primary key into another table. hence i don't think using bulk insert is possible.
im using SQL Server 2000.
Pls help. thank you.
View Complete Post