You are here:
Database Query Limits and Guidelines
Query limits protect the health and performance of the Marketing Cloud Engagement database. There are two types of limits: hard and soft. If you issue a query that exceeds a hard limit, the request is rejected. You can exceed a soft limit, but doing so can degrade performance. Salesforce reserves the right to limit the execution of queries that exceed soft limits if they cause system performance or security issues.
These limits apply to queries issued using APIs and through the web interface.
| Resource | Limit | Limit Type | Details |
|---|---|---|---|
| Maximum number of queries that can be run per day for a single enterprise ID (EID) | The limit depends on your edition.
|
Soft limit | — |
| Maximum run time for a single query | 30 minutes | Hard limit | For best performance, reduce the scope of your queries so that they finish in less than 5 minutes. |
| Data extensions operated upon in a single query | 5 data extensions | Soft limit | For best performance, operate on 4 data extensions or fewer per query. |
| Rows in a data extension | 20 million rows | Soft limit | — |
| Number of joins per query | 4 joins | Soft limit | For best performance, limit each query to 3 joins or fewer. |
| Number of overwrites per automation | 5 overwrites | Soft limit | — |
| Number of queued data extracts | 250 extracts | Hard limit | If 250 or more data extracts are queued in a single Member ID (MID), subsequent data extract requests are rejected. |
Did this article solve your issue?
Let us know so we can improve!
