Performance in multi user environment.

[Nilay Puri, Noida]

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.