How to craete batch files and execute them simultaneously using C# thread

Question

I have code for Database which is about of 4000 lines. It takes around 30 40 min. for executing.

I want to create 20 batch files containing equal lines of command so that I can start them at same time using thread.

None of the batch files are dependent on other. All are independent. Only dependency is all will execute on same database.

Can anyone please guide me how should I proceed so that the time it normally takes to execute is reduced.

What would each of the 20 batch files do? If they access the same tables and potentially lock them while doing the work, running them as seperate threads won't give you much performance gain. — dnolan
– dnolan, Commented Apr 15, 2010 at 12:48

Henk Holterman · Accepted Answer · 2010-04-15 11:24:25Z

1

1) running a series of commands in parallel will not always be faster.

2) to run them in parallel, you don't need batch files. Take a look at Threads or the ThreadPool.

3) To use batch files, write the contents to a (temp) file and execute it using the System.Diagnostics.Process class.

answered Apr 15, 2010 at 11:24

Henk Holterman

275k33 gold badges353 silver badges540 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1