Performance — CAP Best Practices

Primary reference: https://cap.cloud.sap/docs/guides/databases/performance

Rule 1: Always project — never SELECT *

// ❌ Fetches all columns including potentially large localized texts, blobs, etc.
const products = await SELECT.from(Products)

// ✅ Project only what the UI/consumer needs
const products = await SELECT.from(Products)
  .columns('ID', 'title', 'price', 'currency_code', 'category_ID')
  .limit(50)

Rule 2: Push filters to the database / remote service