If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Limit on Query Items

Started by ghostraider, 30 Apr 2008 09:02:33 AM

Previous topic - Next topic

ghostraider

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 :)

blom0344

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?

ghostraider

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

blom0344

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..