[DFC6.7] Performance issue of using CabinetFolderPath method

zm_documentum
zm_documentum
edited April 11, 2016 in Documentum #1

Hi,

Developing with DFC 6.7sp1,

Response speed of API(using cabinet folder path like "/cab1/folder1/folder1_1")  is getting worse.

Sometimes it takes 120sec or more.

Late methods for example  :

"getFolderByPath(String folderPath)"  :  IdfSession

"link(String folderSpec)"  : IdfSysObject.

Is there something considered to be the cause of that ?

And is there anything way to improve that ?

Thank you,

Comments

  • bacham2
    bacham2
    edited April 8, 2016 #2

    What database are you using? How many folders do you have in your docbase?

    r_folder_path is normally indexed, so getFolderByPath should be relatively efficient. Perhaps the index is missing for some reason. In any case, you should probably turn on sqltrace to see what's going on.

    For the link method, you could also specify the r_object_id of the folder if you already have it. Although I'm not sure it would make a big difference.

  • DCTM_Guru
    DCTM_Guru
    edited April 8, 2016 #3

    What are you trying to do when you are executing "folder path like ..."?  Having context sometimes helps determine if there is another option.

  • zm_documentum
    zm_documentum
    edited April 11, 2016 #4

    Hi bacham2,

    Thank you for your reply.

    I use Oracle10g database and the count of folders are about 340,000.

    I will try tracing dfc session.

    If r_folder_path indexes fail function, am I able to re-create the indexes ?

  • bacham2
    bacham2
    edited April 11, 2016 #5

    Yes you can recreate the index using DQL CREATE INDEX if it's missing. I suggest you take a look at a clean 6.7 SP1 docbase to see how it's defined. You can also create the index directly in Oracle but it's best practice to do it via the Content Server (unless you need to use special Oracle features).

Categories