performance with very large frameworks

[blom0344]

Due to technical reasons we are trying to store our whole datawarehouse model within 1 framework. We're talking about hundreds of tables/views and perhaps over thousand objects.
At fasttrack course I was told that there is a direct relation between the size of the framework and the time it takes to load it when one wants to create a new report.

Can anyone comment on this? Experiences?

Ties Blom

 

[mfgf]

Hi,

The time taken to load metadata when using an studio depends on

a. The size of the package (not the framework)
b. Whether runtime metadata caching is enabled.
c. The number of callbacks that need to be made to the datasource to retrieve metadata vs the metadata cached in the RTM file (this depends on how the data has been modelled).

Best regards,

MF.