Why are more queries executed in GET_SEARCH_RESULTS when search is submitted from client application (e.g., IPM)?
(Doc ID 2618827.1)
Last updated on DECEMBER 10, 2019
Applies to:Oracle WebCenter Content - Version 188.8.131.52.0 and later
Information in this document applies to any platform.
The following queries are seen in systemdatabase tracing for the GET_SEARCH_RESULTS when the search is from Imaging (IPM). The queries are executed towards the end after the search query had executed. These aren't executed however when the same search is executed from CS native UI.
The same query is executed for every 25 documents returned in the search results. So, if Max Results was set to 10000 from Imaging, then the above query would execute 400 times. Therefore, it's causing additional load and execution time to complete the search.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document