Nilay Puri, Noida wrote:
Hi All,
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
What could be the possible alternate approach.
Thanks in Advance.
I think if you analyze the situation you will find the bottleneck is in
the database, not Perl. Run a test and use `top -s 1 -u` to see which
process takes the most time. See `man top` for details.
--
Just my 0.00000002 million dollars worth,
--- Shawn
"For the things we have to learn before we can do them,
we learn by doing them."
Aristotle
"The man who sets out to carry a cat by its tail learns something that
will always be useful and which will never grow dim or doubtful."
Mark Twain
"Believe in the Divine, but paddle away from the rocks."
Hindu Proverb
* Perl tutorials at http://perlmonks.org/?node=Tutorials
* A searchable perldoc is at http://perldoc.perl.org/
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
<http://learn.perl.org/> <http://learn.perl.org/first-response>
