[ https://issues.redhat.com/browse/TEIID-5903?page=com.atlassian.jira.plugi... ] Renat Eskenin updated TEIID-5903: --------------------------------- Description: 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? We used {code} @Autowired private DataSource sfds; @Bean @Primary public NamedParameterJdbcTemplate getSfNamedParameterJdbcTemplate() { return new NamedParameterJdbcTemplate(sfds); } {code} And {code} @Autowired private NamedParameterJdbcTemplate sftemplate; long start = System.currentTimeMillis(); SqlRowSet rowSet = jdbcTemplate.queryForRowSet(sql, params); log.info("Time from {}:{}", sourceName, (((double) (System.currentTimeMillis() - start)) / 1000.0d)); {code} was: 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)