Why Global search on search_result.do is taking very long time within CMS? - Support and Troubleshooting

Why Global search on search_result.do is taking very long time within CMS? Issue  Symptoms When user performs global text search within Content Management System (CMS), system takes longer than 2 minutes to get the search results.

However, global search on the platform is faster.

And Global search with in CMS is faster for admin user.

While reproducing the issue, observed below node logs,

When I reproduced the reported issue on your instance, noticed below information from the node logs,

2018-10-04 02:04:13 (241) http-19 New transaction 65CCCF7F4FF8A340B1B04DA28110C75F #382412 /view_content.do

2018-10-04 02:04:13 (935) Default-thread-5 65CCCF7F4FF8A340B1B04DA28110C75F [0:00:01.507] Slow DropZone: bbbbbbbbbbbbbbbb:dropzone0 ... 2018-10-04 02:04:15 (033) Default-thread-5 65CCCF7F4FF8A340B1B04DA28110C75F Slow ACL xxxxxxxxxxxxxx for the path record/kb_knowledge/read, time was: 943 2018-10-04 02:04:15 (086) Default-thread-5 65CCCF7F4FF8A340B1B04DA28110C75F Recursive business rule call for 'User partenaire query' on sys_user: is being ignored. Business Rule Stack: User partenaire query,User partenaire query 2018-10-04 02:04:15 (102) Default-thread-5 65CCCF7F4FF8A340B1B04DA28110C75F WARNING *** WARNING *** Get for non-existent record: sys_user:yyyyyyyyyy, initializing 2018-10-04 02:04:15 (141) Default-thread-5 65CCCF7F4FF8A340B1B04DA28110C75F Slow ACL xxxxxxxxxxxxxx for the path record/kb_knowledge/read, time was: 102 2018-10-04 02:04:15 (186) Default-thread-5 65CCCF7F4FF8A340B1B04DA28110C75F Recursive business rule call for 'User partenaire query' on sys_user: is being ignored. Business Rule Stack: User partenaire query,User partenaire query 2018-10-04 02:04:15 (204) Default-thread-5 65CCCF7F4FF8A340B1B04DA28110C75F WARNING *** WARNING *** Get for non-existent record: sys_user:yyyyyyyyyy, initializing 2018-10-04 02:04:15 (244) Default-thread-5 65CCCF7F4FF8A340B1B04DA28110C75F Slow ACL xxxxxxxxxxxxxx for the path record/kb_knowledge/read, time was: 101 2018-10-04 02:04:15 (301) Default-thread-5 65CCCF7F4FF8A340B1B04DA28110C75F Recursive business rule call for 'User partenaire query' on sys_user: is being ignored. Business Rule Stack: User partenaire query,User partenaire query 2018-10-04 02:04:15 (319) Default-thread-5 65CCCF7F4FF8A340B1B04DA28110C75F WARNING *** WARNING *** Get for non-existent record: sys_user:yyyyyyyyyyy, initializing 2018-10-04 02:04:15 (358) Default-thread-5 65CCCF7F4FF8A340B1B04DA28110C75F Slow ACL xxxxxxxxxxxxxx for the path record/kb_knowledge/read, time was: 112 .... 2018-10-04 02:06:20 (435) Default-thread-2 65CCCF7F4FF8A340B1B04DA28110C75F EXCESSIVE *** End #382412 /view_content.do, user: zzzzzzzz, impersonated by: aaaaaaa@snc, total time: 0:02:07.194, processing time: 0:00:01.331, total wait: 0:02:05.863, session wait: 0:02:05.863, SQL time: 0:00:00.105 (count: 216), business rule: 0:00:00.749 (count: 62) Release Any supported release.

Cause Slow ACL execution for ACL with sys_id=xxxxxxxxxxxxxx and recursive before query business rule on sys_user is happening many times, this seems to be causing the performance issue.

The search_results.do content page dropzones to display most popular and most used articles, thus this invokes the "record/kb_knowledge/read" ACL for lot of KB articles and hence takes longer time to load.

Resolution Review the slow ACL record/kb_knowledge/read and improve the script so that sys_user before query business rule is not invoked recursively.

If not needed, remove the most popular and most used articles from the content page.

Additional Information Global search in Content Management System