Calling ABS() from Excel 10x slower than from VB6 or VBS -
07-05-2005
, 04:06 AM
Good to see Abs() has become a native MDX function in sp4.
But... as we haven't upgraded to that version yet we are confronted with the
following weird behaviour:
MDX with calculated members that make use of Abs() is really slow when
called from Excel2003 VBA. The exact same code in VBScript or VB6 runs more
than 10 times faster! Changing Abs() to VBA!Abs() didn't change a thing.
Connectionstring properties try to force server-side execution. It is the
Cellset.Open() that takes so much longer...
Can anybody explain why code run from VBA behaves different from code run in
VB6 or VBScript ?
Cheers,
Tom
Oh, and will sp4 also have Sgn() natively ? |