COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Framework Manager => Topic started by: NaviGator on 03 Jun 2009 05:54:24 AM

Title: FM Performance ..
Post by: NaviGator on 03 Jun 2009 05:54:24 AM
Hello guys,

I had a FM model that was working fine and i could open the query subject and test the data. Suddenly, The Model has become very slow and when I tried to test any fact that contains for example a million record, it takes very long time - may be hours - and i have to cancel the query.

I have tried to query the same fact in Toad and it is working fine and i don't have any performance problem. Do you have any idea what may be the problem ?

Thanks
Title: Re: FM Performance ..
Post by: blom0344 on 03 Jun 2009 08:49:40 AM
Did you change the test options with regards to the number of rows to test? By default it is set to 25 rows. However, deactivating the restriction of an upper limit could be a serious slowdown..