Search operation is too slow in WebTop

deb123
deb123
edited December 4, 2015 in Documentum #1

Hello Experts,

Kindly let me know any way to improve the search operation performance on my machine. I am using 6.7SP2 version of webtop and doing a simple search for a document named "test". It takes almost 15 minutes to open the document where as for my team member sitting in the PC next to me the search operation is in and around 1 minute for the same document in the same webtop version.

Can anyone suggest the real cause behind this slowness of search operation and how can we fix it? Elaborate me the debugging steps I can use to work on improving the performance of the search operation.

Kind regards

Deb

Tagged:

Comments

  • Jeremy Saumen
    Jeremy Saumen Member
    edited December 4, 2015 #2

    Hi,

    We have experienced a similar case very recently.

    We are using CS 7.1 (DB : oracle 12) with DFS 6.7SP2.

    We found that the SQL query generated from the DQL is different (the security part of the query) when you are in strictly more than 250 groups (select count(*) as cpt FROM dm_group where i_all_users_names = '{user_name}') and the performances are really better in that case.

    perfs.png

    EMC gave us an environment variable to change on the CS to lower that limit: DM_GROUP_LIST_LIMIT (we set the value to 2 because we were in a hurry but with a few tests, you should be able to find where to put the limit). Please note that you have to reboot the server (not only the CS service but the entire machine) for this behaviour to change (at least if your CS is windows based).

    Please note that this explanation won't work (or at least I don't think so) if you are using xPlore to perform the search (it's been a long time since i've used xPlore but if I remember correctly it has its own index for the security).

Categories