COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: Saphira_dragon on 05 Mar 2012 01:05:11 PM

Title: generate are very slow
Post by: Saphira_dragon on 05 Mar 2012 01:05:11 PM
I have a report that takes 60 seconds to show all information about all products, but when I create a prompt just to show the information about one product it takes 8 minutes to show.
Should not be otherwise, the report that show all information about all products it takes 8 minutes and the report that show the information about one product take 60 seconds ? Do you have any idea what could be happens ?


Thanks,
Title: Re: generate are very slow
Post by: cognostechie on 05 Mar 2012 01:27:43 PM
Is it showing all information about all products or just showing you the 1st page? Export it to Excel and see how long it takes. One reason why selecting one product would take longer is because there is no index to support the search so it scans till it finds it.
Title: Re: generate are very slow
Post by: Saphira_dragon on 05 Mar 2012 01:46:51 PM
it showing all information about all products.
Is it possible create a index to a criteria like name product ?