Solved

C# and Batch files

Posted on 2014-04-04
12
341 Views
Last Modified: 2014-05-08
hi

can any one suggest me , how can i use parallel programming , to execute a batch file, as the batch file is taking a lot of time to run , and i want to reduce that

1. a batch file  programme loads a file into database .
2. this takes 4 hours right now , which is too much .
3. I want to use parellel programming to , reduce the total time taken by this.
4. can you please help me to suggest that .
5. i am open for other way of doing this. which reduces the time taken to 20 -30 mins at least .



6. i can not use SSIS to load the file as the batch file is written by different vendor , and is not possible to change.
0
Comment
Question by:BeyondBGCM
  • 5
  • 4
12 Comments
 
LVL 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 250 total points
Comment Utility
if the batch file is written by a vendor, you cannot do a lot ...
unless the batch file has options to call with several parameters, so they could be called "in parallel"...
0
 
LVL 68

Assisted Solution

by:Qlemo
Qlemo earned 250 total points
Comment Utility
Very difficult to provide sound advice here. You are basically telling us "I want to change the batch file, but I cannot change it". As Guy told, if the vendor does not allow for splitting up the tasks or data into several junks and control that from outside, there is no way to do that.
Depending on what the batch does, it might be impossible to reduce the time needed - if there is nothing you can execute in parallel, you can't, e.g. because there are many steps and they all are build on each other, so need to run strictly in sequence.
0
 

Author Comment

by:BeyondBGCM
Comment Utility
that's true , that  i can not change the batch file , but as you know calling batch file in c# using System.Diagnostic.Process , can i use Parallel programming to call the batch file


this is like , right now i am calling Batch file with Process class of Systm.Diagnostic, but it is taking a lot of time to run (4 hours)

now , can i use parallel programming , or other mode , to distribute the load of the execution to multiple processor.
0
 
LVL 68

Expert Comment

by:Qlemo
Comment Utility
No, you can't. Taking four cars to dtive a certain distance will take the same time as with one car, unless you are able to let them drive into different directions.
0
 

Author Comment

by:BeyondBGCM
Comment Utility
that's fine , thanks :)
0
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 

Author Comment

by:BeyondBGCM
Comment Utility
I've requested that this question be closed as follows:

Accepted answer: 0 points for BeyondBGCM's comment #a40022304

for the following reason:

i accept , that there is no solution to this question.
0
 
LVL 68

Expert Comment

by:Qlemo
Comment Utility
0
 

Author Comment

by:BeyondBGCM
Comment Utility
i don't want to go in details of this , as if you can read the book Parallel programming with C# ,by Wrox, they clearly say  , it is possible , but if you say it is not possible , i accept it , i have no time , to get in to the discussion for this. you can close it which ever you want
0
 
LVL 68

Expert Comment

by:Qlemo
Comment Utility
Your misconception is that you have the means to start parallel processing in C# (or C++ or ...), but no influence on the internals of external utilities you start in parallel. You always need to adapt the job to only do a part of the overall task if you want to split execution.
0
 
LVL 68

Expert Comment

by:Qlemo
Comment Utility
Closing recommendation: Split
  http:#a39977429
  http:#a39977443
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Here we come across an interesting topic of coding guidelines while designing automation test scripts. The scope of this article will not be limited to QTP but to an overall extent of using VB Scripting for automation projects. Introduction Now…
This article will show, step by step, how to integrate R code into a R Sweave document
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!

Get 1:1 Help Now