Obj and Rdb methods efficiency
Which methods are more efficient ? obj methods or rdb methods ?
Pegasystems Inc.
IN
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
Pegasystems Inc.
US
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.
incessant
IN
Hi,
Please find the attached screenshot.
Pegasystems Inc.
IN
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
Coforge
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.
Pegasystems Inc.
IN
And in addition to your points we can't update BLOB column using RDB methods.!
Aaseya IT Services Pvt.Ltd
IL
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.