---
schema_version: "1"
id: a4217003c89dedc3a5a3ad4eec875773e2d81c44383c0de5e964efbfa978488a
title: Improve Snapshot Data Recipe Performance with Optimized Upsert and Delete Actions (Generally Available)
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/release-notes/260-0-0/rn_bi_integrate_optimized_upsert_delete_ga.md
canonical_url: https://help.salesforce.com/s/articleView?id=release-notes.rn_bi_integrate_optimized_upsert_delete_ga.htm&release=260&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: f7e6a7fd4bb3bf84b728a25ac2cc708d6ea56f8b9b53a43b9cbc4969fe538579
description: Decrease processing time with quicker data recipe runs. Instead of processing all rows in the snapshot data, the optimized upsert and delete actions run incrementally on subsets of the snapshot data, resulting in faster runs. This feature is now generally available.
release: "260"
---
# Improve Snapshot Data Recipe Performance with Optimized Upsert and Delete Actions (Generally Available)

Decrease processing time with quicker data recipe runs. Instead of processing all rows in the snapshot data, the optimized upsert and delete actions run incrementally on subsets of the snapshot data, resulting in faster runs. This feature is now generally available.

**Where:** This change applies to CRM Analytics in Lightning Experience and Salesforce Classic. CRM Analytics is available for an extra cost in Enterprise, Performance, and Unlimited editions.

**How:** Re-create your recipes to take advantage of this optimization. The snapshot data must contain a primary key field. In the output node, select **Existing Dataset** and then select either the **Upsert** or the **Delete** operation to use the optimized features.