Click here to Skip to main content
15,069,297 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
How to run many INSERT commands parallel? I have a really big query with many insert commands. Need to optimize it to run faster.
Posted
Comments
gvprabu 12-Jun-13 5:22am
   
U need to insert in same table or each insert statements are different table's Insert Process.
gvprabu 12-Jun-13 5:23am
   
give some more Information about your Question.
Maciej Los 12-Jun-13 15:01pm
   
We can't read in your mind...
Please, be more specific and provide more details (code, example data, etc.).

1 solution

Best solution is to create multiple store procedures containing multiple INSERT statements. To be able to run them “parallel“ execute them using different connections.
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900