Diff. times are taken to complete load unload archive and unarchive

[Former Member]

Hi All,

I am facing a problem with loading unloading archiving and unarchiving repository.

Problem is Everyday it is taking different to complete the process. Is the time deneds on the data and images availavle in the repository?

If large amount of data is there then it will take more time to complete all these process or large amount of user are log in it will take more time to unload?

Please Suggest

Thanks

[Former Member]

Hi Shalini,

The repository Archieving and Unarchieving operations involves the data base.

I mean Repository tables and fields and the data of the repository are in the underlying database and You can backup an MDM repository using the MDM archiving mechanism.That will save the repository scema .a2a file for furthere refrence.This schema contains the tables and fields inside the tables and all these things are storesd on the DBMS level.So suppose next time when you unarchieve the repository and made some changes like

1.You have added some new Tables and Fields.

2.You have added new Data.

And all this is getting stored at the database leve at the end.

In this case the amount of data of your repository in terms of Tables and Fields or Data at the DBMS Level.So next time when you take archieve of your Repository It will take some extra time as compare to the previous one.And same thing will happen in case of Unarchieving because this time some new tables and their fields and some new data(images,pdfs etc) they all will be unarchieved as a Part of Repository so it will take a bit extra time to Unarchieve.

Same thing will happen in case of Loading and Unloading as the tables ,fields and amount of data increases the time to load and unload will also increases.

At the time of loading the repository You can go to your MDM Server and check that repository in status it will show checking image ID's ,processing tables,processing sound tables,loading search indexes etc.

Making a few minor adjustment with MDM and/or the DBMS server can enhance search and update performance by 10% to 20%.

SQL Serveru2019s performance increases by about 10% when the main data file (.mdf) and the transaction log file (.ldf) are located on separate spindles. Remember that this means using different drives, not just

different drive letters.

Reward if Helpfull.

Regards,

Vinay Yadav

[Former Member]

Hi Shalini,

As said above time taken to load the repository depends upon the amount of data available in the repository ( mostly rich product containt ).

Along with that it also depends upon the structure of repository. It depends upon no of fields you defined in the repository. It depends upon no of fields for which you have enabled keyword search option. In case of qualifiet table it depends upon Qualifier fields for which you have made Cache on.

It also depends upon landscape of ur MDM technology. It takes lase time if u have used RAM >3Gb, it is better to use separate specialised database server which are used for storage purpose for storing repository containt .

Hope this will help u.

[Former Member]

Hi Shalini,

Following are some of the parameters due to which different operations take different time

1. Number of users logged in - Since MDM Server has to process the request from all the users which increases the load on MDM Server.

2. Number of processes running in the system at a time - Since every process occupies some amount of memory and the memory is limited for the particular system. So more number of processes running, more response time required by MDM Server.

3. Type of Data - If the repository contains huge amount of Multimedia objects like Sound, Images, Video etc it will take time to load since MDM Server fetches data from the database in parts.

There can be many parameters but this is what I feel

Hope it helps..

Regards,

Jitesh Talreja

[Former Member]

Hello Shalini,

The time taken by the Archiving and Unarchiving mechanism of the repository is totally depent on the data and image records in the repository.

IF the large amount of data in a repository then it will take more time as per the records.

I hope this will clear your doubt.

TNR,

Saurabh...

Reward if found helpful.

Edited by: Saurabh Kumar Sahu on Jun 24, 2008 9:00 AM