dbTalk Databases Forums  

Calling ABS() from Excel 10x slower than from VB6 or VBS

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Calling ABS() from Excel 10x slower than from VB6 or VBS in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Tom VdP
 
Posts: n/a

Default 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 ?

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.