salesforce-performance-tuning

# Salesforce Performance Tuning ## Overview Optimize Salesforce API performance: tune SOQL queries, minimize API calls using Composite/Collections APIs, implement metadata caching, and handle large result sets efficiently. ## Prerequisites - jsforce connection configured - Understanding of SOQL query plans - Redis or in-memory cache available (optional) - Access to Setup > API usage monitoring ## Instructions ### Step 1: SOQL Query Optimization ```typescript // BAD: SELECT * equivalent — fetches all fields const result = await conn.query('SELECT FIELDS(ALL) FROM Account LIMIT 100'); // GOOD: Only select fields you need const result = await conn.query(` SELECT Id, Name, Industry, AnnualRevenue FROM Account WHERE Industry = 'Technology' LIMIT 100 `); // BAD: Non-selective WHERE clause (full table scan) const result = await conn.query("SELECT Id FROM Contact WHERE Title LIKE '%Engineer%'"); // GOOD: Use indexed fields in WHERE (Id, Name, CreatedDate, RecordType, lookup fields) const result = await conn.query(` SELECT Id, Name, Title FROM Contact WHERE AccountId = '001xxxxxxxxxxxx' AND CreatedDate >= LAST_N_DAYS:30 LIMIT 200 `); // Use relationship queries to avoid N+1 pattern // BAD: Query Accounts, then query Contacts for each (N+1 API calls) const accounts = await conn.query('SELECT Id FROM Account LIMIT 50'); for (const acct of accounts.records) { await conn.query(`SELECT Id FROM Contact WHERE AccountId = '${acct.Id}'`); // 50 extra API calls!...