[
https://issues.jboss.org/browse/TEIID-4284?page=com.atlassian.jira.plugin...
]
sameer P edited comment on TEIID-4284 at 10/10/16 1:26 PM:
-----------------------------------------------------------
And, I also tried on a small table with some 60 rows and the result is same. That is, it
returns results on first query and it continuously generates requests (which I believe is
the usage of Bulk API) with the above stated statements in the Log and does not come out
at all for the second query.
was (Author: sameerp):
And, I also tried on a small table with some 60 rows and the result is same. That is, it
returns results on first query and it continuously generates requests (which I believe is
the usage of Bulk API) with the above stated statements in the Log and does not come out
at all.
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)