Question
AMEX
US
Last activity: 10 May 2018 14:35 EDT
Obj-Browse vs Datapage (Thread level using Report Definition) which is the best way to fetch data from table
Hi All,
We have a table with Exposed columns, I have to fetch data from the table every time my service is called.
What is the best way to fetch data from a performance / Pega Gaurdrails perspective. (Obj-browse in activity or Datapage in activity / DT)?
Thanks,
Sumanth
Accepted Solution
Pegasystems Inc.
IN
Data page should be the right approach, as it is guardrail compliant and you need not write activity for loading a data page.
You can also write unit tests for data page, so that it can auto tested.
As you need to make a fresh call to db for every interaction, performance wise it would be same for obj-browse and data page + report definition.
In future if you want add joins to your query, obj-browse doesn't support that only report can do it. Considering all these, it would be good go with Data page and report.
Pegasystems Inc.
US
Please check below pdn link:
https://collaborate.pega.com/question/compare-performance-report-definition-and-obj-browse
Pegasystems Inc.
IN
Hi Venkat,
Generally pega recommends if you can avoid using activity with any other alternative you should go for that so for guardrail perspective you should be using Data Page in DT.
Also if you obj-browse every time pega will be a trip to Database with the select statement, but in Data Page it fetches the value based on the refresh strategy you have set.
Regards,
Vikash
Accepted Solution
Pegasystems Inc.
IN
Data page should be the right approach, as it is guardrail compliant and you need not write activity for loading a data page.
You can also write unit tests for data page, so that it can auto tested.
As you need to make a fresh call to db for every interaction, performance wise it would be same for obj-browse and data page + report definition.
In future if you want add joins to your query, obj-browse doesn't support that only report can do it. Considering all these, it would be good go with Data page and report.