Obj-Browse or pxRetrieveData
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). Thanks in advance.
***Edited by Moderator Marissa to update Platform Capability tags****
Accepted Solution
Updated: 29 Apr 2020 1:11 EDT
LTI Mindtree
CA
The obj-browse method would be faster than pxRetrieveReportData, however, it depends on the situation. Let's say 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. On the other hand, if you have a complex query that needs a join the table/s then report definition call via pxRetrieveReportData is the right option.
pxRetrieveReportData - Executes more number rules, but provide more flexibility
obj-browse - light operation, but works for simple scenarios (less flexibility)
Pegasystems Inc.
FR
Hello,
Well I would think Obj-Browse might be launching less rules execution behind the scene right. Obj-Browse is just a method where pxRetrieveData is a full activity calling quite a lot of other rules as well.
Updated: 14 Jun 2021 7:38 EDT
Pegasystems Inc.
IN
I think Obj-Browse would be better as here you will be querying directly to the Database and do you mean pxRetrieveData as pxRetrieveReportData to get the Report details, if yes, in this scenario you need to call the activity and inside this report will be called and it will query the Database, the second option has a lot of process compared to first.
Blue Rose Technologies
DE
Hi,
You can go through below discussions also and see if it is helpful.
https://collaborate.pega.com/question/compare-performance-report-definition-and-obj-browse https://collaborate.pega.com/question/obj-browse-vs-datapage-thread-level-using-report-definition-which-best-way-fetch-data
Accepted Solution
Updated: 29 Apr 2020 1:11 EDT
LTI Mindtree
CA
The obj-browse method would be faster than pxRetrieveReportData, however, it depends on the situation. Let's say 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. On the other hand, if you have a complex query that needs a join the table/s then report definition call via pxRetrieveReportData is the right option.
pxRetrieveReportData - Executes more number rules, but provide more flexibility
obj-browse - light operation, but works for simple scenarios (less flexibility)