Question
VIRTUSA
IN
Last activity: 4 Oct 2019 2:01 EDT
Difference between Obj methods and RDB methods ?
Accepted Solution
Pegasystems Inc.
IN
Hi,
In terms of funcationality both Obj operations and RDB can achive the requirement almost.But performance wise, it's not recommended to use RDB methosd unless we are using external Database to connect and/or we are writing complex data base queries which are not possible with Obj methods.
Obj- operations generate their own SQL while RDB- operations rely on the query written in Rule-Connect-SQL instances.
Obj methods are meant for transactional ease as they have the option of deferred save, rollback etc whereas RDB methods are performed immediately with auto-commit
Hi,
In terms of funcationality both Obj operations and RDB can achive the requirement almost.But performance wise, it's not recommended to use RDB methosd unless we are using external Database to connect and/or we are writing complex data base queries which are not possible with Obj methods.
Obj- operations generate their own SQL while RDB- operations rely on the query written in Rule-Connect-SQL instances.
Obj methods are meant for transactional ease as they have the option of deferred save, rollback etc whereas RDB methods are performed immediately with auto-commit
Thanks
Pegasystems Inc.
IN
Hi Chiranjeevi
Please refer to the following articles it might help you:
https://collaborate.pega.com/question/difference-between-obj-operations-and-rdb-operations-obj-open-vs-obj-open-handle
https://collaborate.pega.com/question/what-difference-between-obj-methods-and-rdb-methods
Pegasystems Inc.
IN
Hi Team,
mainly we use the obj methods for internal tables and rdb is used for external tables to extract the data. We can use the obj methods even to access external tables after you do an external mapping of the class and properties.
Accepted Solution
Pegasystems Inc.
IN
Hi,
In terms of funcationality both Obj operations and RDB can achive the requirement almost.But performance wise, it's not recommended to use RDB methosd unless we are using external Database to connect and/or we are writing complex data base queries which are not possible with Obj methods.
Obj- operations generate their own SQL while RDB- operations rely on the query written in Rule-Connect-SQL instances.
Obj methods are meant for transactional ease as they have the option of deferred save, rollback etc whereas RDB methods are performed immediately with auto-commit
Hi,
In terms of funcationality both Obj operations and RDB can achive the requirement almost.But performance wise, it's not recommended to use RDB methosd unless we are using external Database to connect and/or we are writing complex data base queries which are not possible with Obj methods.
Obj- operations generate their own SQL while RDB- operations rely on the query written in Rule-Connect-SQL instances.
Obj methods are meant for transactional ease as they have the option of deferred save, rollback etc whereas RDB methods are performed immediately with auto-commit
Thanks
Blue Rose Technologies
BE
If we want to customize queries and interacting external DB's , we need to go for RDB Methods.
obj methods take more time when columns are not exposed and can't customize SQL.