glide.db.soft_join_capThe glide.db.soft_join_cap property sets the maximum number of database joins allowed per query. Adjusting this value influences query complexity and performance, with smaller numbers leading to simpler queries and larger numbers potentially increasing complexity.
The answers below summarize the purpose, scope, default effect, and review scenarios for this property.
| What does it do? | This property limits the number of joins in database queries, impacting how the system constructs and executes those queries. |
|---|---|
| What area does it affect? | Database query performance |
| What does the default mean? | The default value is "10", which sets the baseline numeric behavior for this property. |
| When should you review it? | Review this property if you encounter performance issues related to complex queries or large join counts. |
Raw metadata from the property record.
| Property name | glide.db.soft_join_cap |
|---|---|
| Sys ID | 24fca6b00a0a0b15000849578afb1eae |
| Type | integer |
| Application | Global |
| Default value | 10 |
| Description | Maximum number of database joins per query. Smaller values cause the system to issue a larger number of less complex queries. Larger values reduce the number of queries at the cost of additional complexity per query. In the absence of known database issues stemming from large join counts, this property should remain unchanged. |
| Updated | 2024-05-25 03:38:55 |