.Net API Speed Questions
Posted: Wed Jun 24, 2009 4:04 pm
It could just be me, but does anyone else experience extreme performance issues with the .net api when dealing with "large" amounts of data?
I am trying to bring back the expressison of a subset. The current dimension has about 2500 subsets. When I try to run the following code it takes forever and a day to retrieve a result. I have used this against smaller dimensions without issue (nearly instantaneous result), but there seems to be a performance threshhold somewhere based on the number of elements in the given arrays.
Has anyone else experienced this type of slowdown? If so how did you get around it?
I am trying to bring back the expressison of a subset. The current dimension has about 2500 subsets. When I try to run the following code it takes forever and a day to retrieve a result. I have used this against smaller dimensions without issue (nearly instantaneous result), but there seems to be a performance threshhold somewhere based on the number of elements in the given arrays.
Code: Select all
SubMDX = _server.Dimensions[dimension].PublicSubsets[subsetName].Expression.ToString();Has anyone else experienced this type of slowdown? If so how did you get around it?