Skip to Content
0
Former Member
May 28, 2008 at 10:43 PM

Query Performance

19 Views

Hi,

We have a cube which contains tons of data. To improve the performance we created a new multiprovider and now we are repalcing the old query(A) with new query(B) which is built on the multiprovider.

Now my question is when we are running the query we are seeing total time of B is more than the total time of A.

the query is using virtual keyfigures. We are running compression on the new cube in multiprovider.

Does it make any diff? Last week it was ok but this week this behaving diffrently..

The new query(B) is taking more time on OLAP than Old query(B)?

Why it is behaving so?

Any help will be really appreciated.

thanks