Hi All,
I have a perl script which scans for multiple folder and check if any file is dropped in that folder and then it read the contents of the file and then convert the contents as xml and output the file as output.xml and then this perl exe will call a vb exe. The purpose of vb exe is to read the xml and then call a MS-SQL 2000 Stored procedure with this xml as input.
My Question:
1) Is it best to use vb to connect to MS-SQL and then call Stored Procedure with the xml or anyother best at par solution is available in Perl itself.
2) When i run the perl script with around 10 files by commenting without the script calling the vb exe it just takes 2 seconds but when i call vb exe uncommentinternally from the perl and then run the perl script it takes 25 seconds. But when i run the same vb exe individually it takes less than 1 second to update a single xml.
Please help me to sort out this issue...
Thanks in advance! Please let me know if any other information need to be published!!!

The Source Code i have done till now is here http://www.nopaste.com/p/apWkW79Cy/txt

In reply to Running VB Exe from perl takes lot of time by powersakthi

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.