Hi: I am new to Perl and CGI. What I am trying to do is to use CGI to create a form that collects several report parameters(date, region, store,and department) and pass those to a perl script, which runs a SQL to produce a report, the output will be saved as a tab delimited file.
I am using database link to query two database, and doing lots of calculation in the query to get the sales information.
My SQL processes large amout of data and takes more than 10 minutes to run; since the null value and different digit for same field in the different tables, I have to use case, substr, nvl function in the query. These all require lots of time.
In order to save time,i choose not to display results on the web form, just write them directly to tab delimited file.
And I use a cgi script to create the html form, collect and pass parameters. another perl script does the SQL and write the output to a file, and send an email which has a link to where the results is stored. Using CGI to call Perl, hope the process will be run in the backgroud to get round the timeout issue.
I tested it in the command prompt and on the web, it can handle a couple of thousands records. But most of the time it just time out and send no email.
I am wondering if anyone encountered the timeout problem before and how to deal with it?
Anything can be changed on the server configuration side? Or just CGI perl is not the solution for process large amount of data?
I am new college graduate, and this is my first experience with perl. Any advice will be appreciated.
Thanks in advance.
jewang

In reply to Perl CGI timeout by jewang

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.