On 3/24/06, Nilay Puri <[EMAIL PROTECTED]> wrote:
> My perl script connects to database and picks up data and generates an
> excel file.
>
> This script is triggered from front end. In multi user environment if 10
> users
> simultaneously starts using the perl script the performance goes down as 10
> perl script are executed at back end which takes up CPU time
If all ten of them are going to end up seeing the same excel file, you
should probably generate it once (hourly or daily?) and store it in a
file, rather than regenerating it ten times.
But if it's a custom report for each, you might use the technique from
one of Randal Schwartz's columns. Although the column deals with
search results, it works just as well for what you're doing. This one
can give the users an immediate page so that they know that the excel
file is being generated, and later they can see the finished file when
it's ready.
http://www.stonehenge.com/merlyn/WebTechniques/col20.html
Hope this helps!
--Tom Phoenix
Stonehenge Perl Training
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
<http://learn.perl.org/> <http://learn.perl.org/first-response>
