Description:
It is taking the mart server a very long time to cache my models for the reporting. Is there any way I can speed that process up?
Solution:
One quite likely reason could be that the data in the databases where models reside may be fragmented. It helps to create an Index for faster retrieval of the data from Mart. To do so, run this query on the DB where Mart resides:
CREATE INDEX XAK2M9OBJECT on m9Object (O_ParentId, C_Id,O_Type, O_EndVersion, O_Id);
QA executed the following test case with the following results in our environment:
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center