Hi,
I am observing a degradation in the CellSet.get_Item function times as I traverse through the Cellset return in response to a MDX query.
The .NET (C#) application fires an MDX queries and traverses each Cell in the returned CellSet. The traversal is sequntial and in the order of the Cells Ordinal number. What I observe is that the CellSet.get_item function time increase as the traversal progresses.
For the first 2000 cells the time taken is between 35-50 micro seconds. Subsequently, the performance degrades and by the 10,000 cell access the time taken by the function is about 1.2ms which is about a 30X degradation.
Is this because of the client side caching behavior of the the PivotService table ? If so, what is the optimal traversal behavior for the cache ?
Any ideas on how to identify the problem and optimize it will be appreciated ?
Thanks in advance,
Midhun