Details
-
Enhancement
-
Resolution: Not a Bug
-
Major
-
None
-
13.0.2
-
None
Description
If we call SOQL
SELECT Account.BillingCountry__c, Account.Name from Contact LIMIT 1
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:
SELECT Account.BillingCountry__c, Account.Name from Contact LEFT OUTER JOIN /*+ MAKEDEP */ Account on Contact.AccountId = Account.id LIMIT 1
we have request time: Time from sf:3.561s
How we can optimize request time?
We used
@Autowired private DataSource sfds; @Bean @Primary public NamedParameterJdbcTemplate getSfNamedParameterJdbcTemplate() { return new NamedParameterJdbcTemplate(sfds); }
And
@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));
