[DFC6.7] Performance issue of using CabinetFolderPath method

zm_documentum

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,

Find more posts tagged with

Comments

bacham2

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

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

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

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