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 Priority: Major 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}