Details

    • Type: Enhancement
    • Status: Resolved (View Workflow)
    • Priority: Major
    • Resolution: Explained
    • Affects Version/s: 13.0.2
    • Fix Version/s: None
    • Component/s: Salesforce Connector
    • Labels:
      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));
      
      

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                shawkins Steven Hawkins
                Reporter:
                i3draven Renat Eskenin
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: