[teiid-issues] [JBoss JIRA] (TEIID-4284) Implement Salesforce Bulk API for SELECTS to Salesforce Connector
[
https://issues.jboss.org/browse/TEIID-4284?page=com.atlassian.jira.plugin...
]
sameer P edited comment on TEIID-4284 at 10/13/16 12:12 PM:
------------------------------------------------------------
Yes exactly Steven, and one more interesting thing is that, as I went through the
Salesforce web UI which shows the number of batches that will be created for a submitted
query, there will always be a single batch that will be created on first query
(irrespective of how big the table is). And from the second execution of the same query on
wards, the query will be distributed into batches. Is this the expected behavior?
was (Author: sameerp):
Yes exactly Steven, and one more interesting thing is that, there will always be a single
batch that will be created on first query (irrespective of how big the table is) and from
the second execution of the same query on wards, the query will be distributed into
batches. Is this the expected behavior?
Implement Salesforce Bulk API for SELECTS to Salesforce Connector
-----------------------------------------------------------------
Key: TEIID-4284
URL: https://issues.jboss.org/browse/TEIID-4284
Project: Teiid
Issue Type: Feature Request
Components: Salesforce Connector
Affects Versions: 8.13.5
Environment: With Salesforce datasource
Reporter: sameer P
Assignee: Steven Hawkins
Fix For: 9.1
There is some huge data (many GBs) in the Salesforce which has around 1.5 million rows
and doing some simple select * on it fails with QUERY_TIMEOUT.
The salesforce guys suggested to try Bulk API for select with PK chunking as stated in
https://developer.salesforce.com/docs/atlas.en-us.api_asynch.meta/api_asy...
.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)