I've been using ADOMD from C# for some time now after we determined
that ADOMD was generally faster than ADOMD.NET. I am running Analysis
Services 2000 SP4 connecting to a SQL Server 2000 SP4 database.

However, I've come across a particular query now that causes
Cell.FormattedValue to take about a 1/2 second. This may not seem like
a long time, but when I have about 20 rows to process, it is really
hurting performance. Cell.Value is equally slow. It turns out that in
ADOMD.NET, Cell.FormattedValue returns immediately.

I am using the general algorithm described in the MS KB article to
retrieve values from ADOMD using C#.
(http://support.microsoft.com/default...b;en-us;828279)

It was my understanding that the ICellset.Open() call is what actually
executed the query and would take time to complete. After that, I
expected that retrieving the values from the Cell (using the
FormattedValue and Value properties) would be instantaneous. However,
this does not appear to be the case. The documentation does not really
lend any clues that I can see as to why this might be happening.

What is Cell.FormattedValue doing in ADOMD that would cause it to take
so long in certain circumstances? I'm hoping that a better
understanding of what this property does would lead me to a better
performing algorithm for retrieving values from a Cellset. I would like
to continue using ADOMD if possible due to the perceived general
performance characteristics, as well as because it is a known quantity
at this point since I have been using it for quite a while.

Thanks!