Question

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

**Moderation Team has archived post**

This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.

Correct Answer
May 9, 2018 - 3:35am

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.

Comments

Keep up to date on this post and subscribe to comments

May 8, 2018 - 9:30pm

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

Pega
May 9, 2018 - 3:35am

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.