Tuesday, 21 November 2017
     
AUSQLUG Forums Home   Search   Login   Register   Member List  
SQL Server 2005 Forums  > Service Broker  > Insert performance - SQL Server 2005  
 
Display using:  
Previous Thread :: Next Thread 
 Author Thread: Insert performance - SQL Server 2005
RyanCaleb is not online. Last active: 8/11/2017 11:20:51 PM RyanCaleb
Top 25 Poster
Joined: 13 Sep 2017
Total Posts: 66
 
Insert performance - SQL Server 2005
Posted: 14 Oct 2017 07:05 PM
i!

I'm running a Insert/Update in a SQL Server 2005 database, that has to process around of 500,000 rows. The process finishes after 20 minutes.
Is there a way to improve the performance of this process?
I'm using the Optim Test Data Management Enterprise Edition 11.3. The database is the SQL Server 2005. The ODBC connection was created using the Native Driver Client 11.0. S.O Windows Server 2008 x86_64.

Thanks
I didn't find the right solution from the Internet.


References https://www.ibm.com/developerworks/community/forums/html/topic?id=c31d8efa-dccf-4751-96ab-2eb54b54e7b9

animated video explainer
Previous Thread :: Next Thread 
Page 1 of 1
 
AUSQLUG Forums  > SQL Server 2005 Forums  > Service Broker  > Insert performance - SQL Server 2005