[teiid-issues] [JBoss JIRA] (TEIID-5903) Performance problems

[Renat Eskenin (Jira)]

Renat Eskenin created TEIID-5903:
------------------------------------

             Summary: Performance problems
                 Key: TEIID-5903
                 URL: https://issues.redhat.com/browse/TEIID-5903
             Project: Teiid
          Issue Type: Enhancement
          Components: Salesforce Connector
    Affects Versions: 13.0.2
            Reporter: Renat Eskenin
            Assignee: Steven Hawkins


If we call SOQL
{code:sql}
SELECT Account.BillingCountry__c, Account.Name from Contact LIMIT 1
{code}
We have time in salesforce workbench (UI for SOAP): Returned records 1 - 1 of 1 total record in 0.947 seconds:

If we call SQL over teiid spring salesforce example:

{code:sql}
SELECT Account.BillingCountry__c, Account.Name from Contact LEFT OUTER JOIN /*+ MAKEDEP */ Account 
on Contact.AccountId = Account.id 
LIMIT 1
{code}

we have request time: Time from sf:3.561s

How we can optimize request time?



--
This message was sent by Atlassian Jira
(v7.13.8#713008)