Export Query Performance Throttles
The following export query performance throttles apply to the EXPORT web service only.
| Since | Default Value | Comment | Behavior |
|---|---|---|---|
| 7.5 SP2 | 5 | The maximum depth of relations that can be specified in an export query (max.relation.deepness) | All performance throttles are checked before extracting the data. |
| 7.5 SP2 | -1 | The maximum number of relations that can be specified in an export query (max.relation.count) | |
| 7.5 SP2 | 1 | The maximum number of subqueries that can be specified in an export query (max.subquery.count) | |
| 7.5 SP2 | 5 | The maximum number of fields that can be specified to filter an export query (max.filtering.field.count) | |
| 7.5 SP2 | 5 | The maximum number of fields that can be specified to group fields in an export query (max.grouping.field.count) A grouping field represents a value used to group query results. In SQL, it will be pushed into the GROUP BY clause. |
|
| 7.5 SP2 | 5 | The maximum number of fields that can be specified to join other queries in an export query (max.jointing.field.count) A joint field represents a filter used to join a parent and a sub-query. In SQL, the filter will be pushed into the WHERE clause of the parent query. |
|
| 7.5 SP2 | 1 | The maximum number of levels for sub-queries that can be specified in an export query (max.subquery.level.count). | |
| 7.5 SP2 | 100 | The maximum number of fields that can be projected in an export query (max.projection.field.count) A projection field represents a value returned by a query. In SQL, it will be pushed into the SELECT clause. |