Page 1 of 1
Slower after converting into static values?
Posted: Mon Jun 26, 2017 3:53 am
by macsir
Hi, I have a complex view which takes around 6 minutes to build using rule. The base data is referred from another cube using DB function. To speed up, I convert this part of base data into static values using TI procee and disable the DB function. The result is right but building that view even takes longer time which is around 14 minutes now. I can't understand...
Re: Slower after converting into static values?
Posted: Mon Jun 26, 2017 7:48 am
by Steve Rowe
Can I check you have restarted after making the change, cleared away and .FEEDER files?
I can't think of anything really obvious, maybe you need to fiddle with the dimension order as making values static might have changed the sparcity in some way, though I'm not 100% sure that would make sense..!
Re: Slower after converting into static values?
Posted: Mon Jun 26, 2017 8:29 am
by macsir
Steve Rowe wrote:Can I check you have restarted after making the change, cleared away and .FEEDER files?
I can't think of anything really obvious, maybe you need to fiddle with the dimension order as making values static might have changed the sparcity in some way, though I'm not 100% sure that would make sense..!
Thanks, steve. Yes, after rebooting. It is faster although not fast eoungh as i expected.