How to effectively search through the embedded page list in pega Strategy.
We are currently using IsInPageList function in the strategy to check if a customer has some attribute in the embedded page list.
But in some cases we are having a high number of these page. around 50k. When using IsInPageList it performs a search in each page one by one in a loop.
Is there a way we can search for any item in the array using binary search or any other technique without looking into each page one by one which will be faster.
The performance of the strategy is very poor because of this.
Virtusa
IN
Tata Consultancy Services
IN
@RAJAG653This data is load in Dataflow. So when a Pega campaign runs in CDH it runs a dataflow then data sets which loads these page lists.
Updated: 11 Mar 2025 6:12 EDT
Virtusa
IN
@B.Puneet If such is the use case then
- it's better to go for flag property created for top context page like on Subscription /account level depends on the outbound campaign context as well as based on the property linked to corresponding entity. Setting of this property is to be handled either by ETL jobs or can be set along with any real time aggregate properties by pega
- Another approach is to create either Data page/report definition for that Page-List record class with condition as .property not null along with account-id/ subscription-id. Using this approach you need to set flag property/derive your logic at data flow level itself
So approach needs to be like, before we enter our strategy with such complex condition set already rather than evaluating inside our decisioning module
Tata Consultancy Services
IN
@RAJAG653Yes we had this option as a last resort. But just wanted to check if there is any other searching logic at the strategy level.
Hi @B.Puneet
Is it possible to provide more details on this, like from where you are getting this page List. What is the source of this page List. This will help to understand why we are ruling out declare index rule for this page List