Best Practices for Optimizing Usage

To stay within your consumption credits, follow best practices to optimize your service and data usage.

Customer and Salesforce partners can follow these tips.

Optimize Your Code for Best Performance

Write optimized code that’s inexpensive, such as queries. You can write SQL queries to fetch only the data that you need. Queries are preferable over GET API requests because they offer more flexibility in choosing the data that you want to retrieve. To write efficient queries, add a WHERE clause to filter the returned results and retrieve the smallest set of required records. Also, specify only the fields that you need in the SELECT statement.

For example, this query is efficient because it gets one Individual record for a specific Individual ID value.

Connect REST API resource:

1/ssot/query-sql

SQL query:

1{
2    "sql": "select BirthDate__c, DataSourceId__c, DataSourceObjectId__c, ExternalRecordId__c,
3        FirstName__c, GenderId__c, Id__c, InternalOrganizationId__c, LastName__c
4        from Individual__dlm where Id__c='100470169'“
5}

You can query data via Connect REST API. See the Query Library section in Data Cloud Resources in the Data Cloud Connect REST API Guide. Or see Query Data using Query API and Query Customer Profile Information with Profile API in the Data Cloud Query Guide. Alternatively, you can use SOQL to query data. For more information, see Data Cloud Query Profile Parameters in the REST API Developer Guide.

Selective Data Ingestion

As part of your data ingestion strategy, ensure that you import relevant data records into Data 360 and that you don’t import more data than what’s needed. Sometimes it’s better to aggregate data before ingesting it rather than ingesting every data point, especially if not all attributes are relevant.

Limit Test Data

When testing a custom app, limit the amount of testing data in the test org. Use a sample of records that’s sufficient to meet your functional testing needs.