Hello

I cant think of any other approach .

Other possible method could be "Pega Merge Into " . but in your case I dont think it will be applicable. 

There is definetly a need to use this carefully as it might incur performance overhead. 

Hi Komarina,

Did you try building a reusable function rule for this purpose. Have 3 parameters to the function;

1. PageList A (DataPage / 5000 results) / 2. PageList B (600 results) / 3. PageList C (populated by Page-Copy)

If the you get any issues with referring the data page directly from a function, you can setup a pagelist property with reference set on data page.

Try this with your earlier benchmark? you might get a improvement.

Disadvantages -

1.The IsInPageList and the other when conditions will go inside the function. But you can improve reusability by creating seperate WHEN rules instead of hard coded expressions. So that if the conditions change, you can change the WHEN rules without touching the Function rule.

2. If the other pre-conditions contain references inside the two page lists you won't be able to use WHEN rules separately. (because they are parameterized to the function)

3. The code will look a bit messy

We just dealt with this same issue. Page-Copy is a very expensive operation -- no getting around it. It's tempting to think that the data retrieval is the expensive bit, but if you're retrieving from a tuned database then No! Ironically the in-memory iterate and page-copy is orders of magnitude slower than the database call-and-populate.

With 5000 items there is little you can do to speed that up with these methods. However, if you're willing to stretch the Guardrails, you can fix this...

If possible, use Obj-Browse or report definition to retrieve the exact values you want into an editable (throwaway) Data Page. Then use a Java step or a function to call the Public API Clipboard.move() function to steal the  pxResults property from the Data Page to wherever you need it. This operation is nearly instant. For us, this turned a 40 second process into a 4 millisecond process.

Caveats: All filtering dependencies must be exposed in the database. The source data should be trusted. I suspect that Page-Copy might be slow because it triggers validation? Don't really know. But this technique will skip it.

If you cannot reload the source data every time, I did find that performing a data transform pxResults <- pxResults took have the time compared to individual Page-Copy of each pxResults item in an Activity.

Good luck!

Hi Komarina,

Since the source and destination used in your Page-Copy are properties of type Page-List, You can use Property-Set method instead of Page-Copy.

Eg:- For each page in datapage

Property-set PageListB.pxResults(<APPEND>) = DataPage.pxResults(<CURRENT>)