Getting the Results from DB table.
Considering performance into account, which is the best option to use for getting results from DB table in the activity. Obj-Browse or pxRetrieveData (OOTB activity)?
Accepted Solution
Updated: 11 Jun 2024 5:27 EDT
Eclatprime Digital Private Limited
AU
pxRetrieveReportData - Executes more number rules, but provide more flexibility like joins and association
obj-browse - light operation, but works for simple scenarios (less flexibility) as a simple requirement to pull data from the table and it fetches the results quickly
so if you have a simple requirement to pull data from the table then you can go with an obj-browse method and it fetches the results quickly.
Pegasystems Inc.
CA
I recommend retrieving the results from the DB table using the Data Page.
From a best practice standpoint, Obj-Browse is not recommended unless you can't achieve through the alternative approaches. Please find the below link for your reference
https://support.pega.com/question/alternative-approach-obj-browse
Accepted Solution
Updated: 11 Jun 2024 5:27 EDT
Eclatprime Digital Private Limited
AU
pxRetrieveReportData - Executes more number rules, but provide more flexibility like joins and association
obj-browse - light operation, but works for simple scenarios (less flexibility) as a simple requirement to pull data from the table and it fetches the results quickly
so if you have a simple requirement to pull data from the table then you can go with an obj-browse method and it fetches the results quickly.