Hi
I have a .exe written in Visual Basic 6 which reads from an Oracle Database and writes one row to an
Excel worksheet using an application ref object (Note: I'm a java developer farly new to VB!). Most
calculations are performed internally (i.e. not within the Excel worksheet) and the problem is:
On Workstation 4 256Mb RAM, 16Gb disc space, 233 Mhz
: it takes on average 1 min to complete this operation.
On Server4 512MbRAM, 16Gb disc space, 700 Mhz (Dual Processor)
: it takes on average 3-4 min to complete this operation.
Why the discrepancy ?
Any thoughts ?
Regards
Hugh O'Donnell
Software Engineer
Ingenco




Reply With Quote