Hi,
We have a serious performance problem with an Excel application when it is
used on a satellite station (any one of the many there are) but there is no
problem when the same application is used on the central server. The WAN is
configured properly but the data to be read is always increasing and I'm
trying to find a solution to it, asap.
The problem appears because the Excel application has to open between 1500
and 2000 excel files to produce a report. This task necessarily takes a long
time to execute because of the 256 or 512 K band width that is used.
I thought of a possible solution but wander if it possible and if it would
be good enough as performance gain. Here is my idea:
I would split the application in two and place the code that opens the 2000
Excel files in a second Excel application on the central server. Then, I
would use the first application from the satellite site and call the process
(the second Excel application) that resides on the central server to do the
dirty job directly on that central server where performance is acceptable.
With such a set up, will the process be faster? Will the server memory be
used or will the process be executed on the satellite site using this
station's memory?
Does any one knows?
Any ideas?
Thank.
--
Jac Tremblay