To whom can help,
I am using Sql Server 2000 and have a linked server to Oracle.
I am doing an insert into the oracle from data on the Sql Server 2000.
it is taking 26 minutes to process 2210 records. at 85 records per minute this appears to be a long time for a relatively small amount of records.
Someone has mentioned that I may be inserting each record row by row instead of all 2210 at the same time. is this possible and if so how can I check.
Basically I want to speed this up (hopefully using setup) and not have to give the answer to the client that their network is rubbish.
Any suggestions or pushes inthe right directions would be useful.
Provider using: Microsoft OLE DB Provider for Oracle (Currently Can't get Oracle Provider for OLE DB to work (error 7399 returned) should I get this working?)
Insert into OpenQuery (FinPRUAT, 'Select Field1 From Table1 Where Field1 1=0')
Select Field1 From Table1
Inner Join Table2
On Table2.Field1 = Table1.Field1
Where Table2.Field2 = 10001228