You can translate the question and the replies:

Performance optimization with Salesforce Instance

We've established connectivity with Salesforce using oAutho2.0 & custom wrappers in Denodo. Retrieved few objects using "com.denodo.connect.salesforce.rest.wrapper.SalesforceRestSelectWrapper". However, duration to extract data from SF with 1 or 2 objects taking more time. Could you please suggest best practices/optimziation techniques to be followed with SalesForce for better performance. Currently we are not doing any hight intensity operation, rather joining Account & Opportunity objects which has only 100K data in SF instance. Appreciate any pointers on the above issues. Regards Karthik
user
22-08-2017 13:13:10 -0400

1 Answer

Hi, On executing a query, Denodo Platform would delegate the query to its sources to improve the performance. When you use a Custom wrapper (Salesforce) as a data source, the delegation of join operation is not supported. In order to improve the query performance, I recommend you to use full cache mode over the base views and the join operation would be delegated to the cache database. As Denodo supports Incremental Queries, you could get the updated results from the Cached database. You could refer the Knowledge Base article “[Incremental Queries in Denodo](https://community.denodo.com/kb/view/document/Incremental%20Queries%20in%20Denodo?category=Performance+%26+Optimization#h.ebmopw5tqct)” section Salesforce for the more information on implementing Incremental Queries. Hope this helps.
Denodo Team
23-08-2017 09:20:42 -0400
You must sign in to add an answer. If you do not have an account, you can register here