Difference between Obj methods and RDB methods ?
When do we use Obj methods for external table and when do use RDB methods for external table?
What were the difference between OBJ vs RDB methods.
I know we can use both methods for external tables, but when we prefer to for Obj methods and when we prefer to go RDB methods.
Please help in understand of these two types of methods.
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
Keep up to date on this post and subscribe to comments