Question
Difference between Obj-operations and RDB-operations? Obj-open vs Obj-open-by-handle?
1) Can anyone tell me what is the difference between Obj-operations and RDB-operations?
a)In terms of performance.
b)In terms of functionality
c)In terms of Limitation i.e. when to use what?
2) exact difference between Obj-open vs Obj-open-by-handle?
a)In terms of performance.
b)In terms of functionality
c)In terms of Limitation i.e. when to use what?
Can you explain me with example to understand better?
Thanks in Advance.
***Updated by Moderator: Vidyaranjan. Removed user added #helpme and Ask the Expert tags. Apologies for confusion, shouldn't have been an end-user option***
**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.
Obj- operations generate their own SQL while RDB- operations rely on the query written in Rule-Connect-SQL instances. Unless there is a need for custom SQL which cannot be solved by Obj- operations, RDB- operations are best avoided. That said, in situations where you need to insert using a select statement or delete multiple records based on a filter criteria, equivalent Obj- operations are currently not available and thus RDB- operations are useful.
Obj-Open opens the instance of a class based on values for all the key properties as defined in the class definition. Obj-Open-By-Handle opens the instance of a class based on just the pzInsKey of the record. If pzInskey is present (which means this is not an external class), being the primary key for the table, this query should perform faster since there would be an index for it.