Closed
Obj and Rdb methods efficiency
Which methods are more efficient ? obj methods or rdb methods ?
This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.
Which methods are more efficient ? obj methods or rdb methods ?
Hi,
Generally all queries should be through the use of Obj methods. If you use RDB methods, you will not be able to access BLOBs. However, RDB methods are necessary if you want to execute stored procedures.
DB methods would be considered in the below factors
1) stored procedure
2) custom or complex query
3) SQL functions
Hi,
Generally all queries should be through the use of Obj methods. If you use RDB methods, you will not be able to access BLOBs. However, RDB methods are necessary if you want to execute stored procedures.
DB methods would be considered in the below factors
1) stored procedure
2) custom or complex query
3) SQL functions
Regards,
Vinay Reddy
It is their usage that is different.
In most cases, use RDB rules only with an external database, and use the Obj-Open and Obj-Save methods, not the RDB- methods, with the PegaRULES database to prevent loss of data.
Both operate on SQL queries, so I believe both are equally effective.
Hi,
Please find the attached screenshot.
Hi There,
It depends on your scenario, if you wish to open the blob use obj-method and if you want to raw sql query and have correct indexes to support it, use RDB method.
Regards,
Ujjwal
Whatever we do with rdb methods can also be done with obj methods also,but only difference is stored procedures and very complex with join conditions canbe done only thorugh RDB Methods.
And in addition to your points we can't update BLOB column using RDB methods.!
Hi Anuj,
In comparision with efficiency, RDB methods gives good efficiency but conditions apply* that also depends on the business scenario. Obj-methods communicates with classes followed by it will interact with Databas Table. WhereAs, RDB methods contains SQL Queries that directly communicates with the database and performs the query.
Question Solved
Discussion
Question Solved
Question Solved
Question
Question
Discussion
Question
Question
Question
Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.