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 or something?
Brian
Oops, that dratted reply bug has hit again!
\ /
o
-( )-
-( )-
-( )-
(_)
I don't use Spreadsheet::WriteExcel but if it's so slow here's an idea.
If the output involves only data, that is, no formulas or macros, then
you could output it in Comma-Separated-Values format (CSV) and load it
into your spreadsheet that way. There are a number of modules on CPAN
<http://cpan.org/> that can do this.
But then again, I still would do a test on the server just to make sure
it is not the cause of the problem.
--
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>