glide.db.soft_join_cap Limits the number of database joins allowed in a single query. At the default of 10, lower values produce more, simpler queries, while higher values reduce query count but increase query complexity; leave it unchanged unless large join counts cause database issues.
10The 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 |
Official references and nearby text excerpts where this property appears.
glide.dbOther properties in the same namespace.
glide.db.replicate_url
This property defines the primary URL used for database replication, ensuring that data is synchronized across
glide.db.replicate_user
This property configures the User ID used for establishing a connection to the primary database for replicatio
glide.db.rotation_validate_fields
This property enables or disables the validation of fields when performing database rotation, impacting data c
glide.db.separation.field
This property controls whether the company separation feature is active, allowing for proper management of dom
glide.db.stats
When enabled, this property logs queries that exceed the duration specified by glide.db.stats.threshold, helpi
glide.db.stats.threshold
This property defines the maximum execution time for database queries to be logged as slow, aiding in performa
glide.db.table.update_inactive_choices_enabled
Determines whether application installation loads choice selections marked inactive in sys_choice into client
glide.db.truncate_utf8
This property configures the truncation behavior for large request payloads, allowing for safer handling of mu