One way would be to have the user's form create a text file on the server and then have a background process do the report generation sequentially. That might make certain users take a little longer, but if your machine is bogged down it might make the whole process faster in the end.
Another possibility would be to create a tab-separated .txt file. Excel will automatically split it on the right fields and you don't have to worry about pesky commas in your data. -----Original Message----- From: Nilay Puri [mailto:[EMAIL PROTECTED] Sent: Friday, March 24, 2006 2:42 AM To: beginners@perl.org Subject: Performance in multi user environment 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. Thanks & Regards, Nilay Puri --------------------------------- New Yahoo! Messenger with Voice. Call regular phones from your PC for low, low rates. -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] <http://learn.perl.org/> <http://learn.perl.org/first-response>
