COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Framework Manager => Topic started by: ghostraider on 30 Apr 2008 09:02:33 AM

Title: Limit on Query Items
Post by: ghostraider on 30 Apr 2008 09:02:33 AM
Hi, is there a certain limit on the number of query items that can exist in a model query subject? I have one model query subject where there are around 60-70 items and whenever i add a new item to this subject it takes a very very long time to get updated. Has anyone experienced this kind of a problem, please let me know.

Thanks :)
Title: Re: Limit on Query Items
Post by: blom0344 on 30 Apr 2008 02:33:59 PM
Quote from: ghostraider on 30 Apr 2008 09:02:33 AM
Hi, is there a certain limit on the number of query items that can exist in a model query subject? I have one model query subject where there are around 60-70 items and whenever i add a new item to this subject it takes a very very long time to get updated. Has anyone experienced this kind of a problem, please let me know.

Thanks :)

60-70 query items should be no problem whatsoever. The only 2 actions that are really performed are:
1. adding a new entry into the model.xml.
2. adding an entry to the logfile that contains all mutations for every save
However..
If you are opening a framework that is not locally stored on your desktop/laptop but on a remote server, than these type of actions can take quite a lot of time. In fact you can end up with a corrupt model if you are working through the network. Are you working with a local copy?
Title: Re: Limit on Query Items
Post by: ghostraider on 30 Apr 2008 04:07:32 PM
I am sorry i put in a rough estimate of the items but when i counted now it is about 150. I am working on a local copy.

Thanks
Title: Re: Limit on Query Items
Post by: blom0344 on 01 May 2008 02:11:17 PM
Create a new Framework based on the minimum set of the namespaces involved with the query subject. Now check whether adding new query items is still very slow. If much faster the problem would be the update of the model.xml.
However I've worked with a 14 MB model.xml where updates to the .xml were still fast enough..