WLP Upgrade to Latest Versions Cause Too Many Database Calls For Content Selector Or Content Search Query
(Doc ID 1312701.1)
Last updated on JANUARY 07, 2022
Oracle WebLogic Portal - Version 10.3.0 to 10.3.4 [Release AS10gR3] Information in this document applies to any platform.
After upgrading WLP to 10.3.x versions and whilst running a content search query or using content selector, the resulting SQL query produced is being executed in the database several times for a single request. Under heavy load the performance of the database is adversely affected by these additional SQL executions.
To illustrate this: the following content query, when executed once using the API below, will result in 3 hits on the database:
Sample multiple DB Queries generated while using default WLP Repository:: ======================================================================= SELECT DISTINCT CM_NODE, NODE_ID FROM CM_NODE, CM_PROPERTY A1 WHERE CM_BODE,NODE_ID AND CM_NODE.LIFECYCLE...
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!