Re: Performance in multi user environment.

2006-03-27 Thread Jay Savage
On 3/24/06, Mr. Shawn H. Corey <[EMAIL PROTECTED]> wrote: > Brian McKee wrote: > > au contraire - If he is using the Spreadsheet::WriteExcel I'm sure it > > buries his server - > > it hits mine hard with just one user. > > > > I don't have a solution, just a comment that it's a real problem. > > I

RE: Performance in multi user environment

2006-03-24 Thread Timothy Johnson
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 po

Re: Performance in multi user environment.

2006-03-24 Thread Mr. Shawn H. Corey
Brian McKee wrote: au contraire - If he is using the Spreadsheet::WriteExcel I'm sure it buries his server - it hits mine hard with just one user. I don't have a solution, just a comment that it's a real problem. I don't suppose you could pre-generate some of the requests? like during off-hours

Re: Performance in multi user environment

2006-03-24 Thread Tom Phoenix
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

Re: Performance in multi user environment.

2006-03-24 Thread Mr. Shawn H. Corey
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