SOQL returning large number of rows crashes the IDE
Issue #1674
resolved
I noticed when i query something in production in SOQL editor if the number of rows returned are large the IDE just freezes. We then need to restart IDE.
Comments (3)
-
repo owner -
reporter Thank you
-
repo owner - changed status to resolved
Fix delivered in 2.1.3.4. From the release notes:
Issue 1674 - Added three new configuration options to the SOQL Query tool window:
- Validate query result set size - When enabled, a count query is executed first to determine whether the number of rows returned would exceed the configured maximum query result set size. This validation is disabled by default.
- Validate unconstrained query result set size - When enabled, a count query is executed first for unconstrained queries to determine whether the number of rows returned would exceed the configured maximum query result set size. Unconstrained queries are those with no
WHERE
orLIMIT
clause, or those with aLIMIT
clause that exceeds the configured maximum query result set size. This validation is enabled by default. - Maximum query result set size - The value used by the two constraints above when enabled. The value must be in the range 100-50K inclusive and defaults to 5K rows.
All SOQL Query configuration options have also now been moved into a configuration dialog accessible from the SOQL Query tool window toolbar.
- Log in to comment
Pranay, IC tries to guard against this by prompting when you run an unconstrained query (or
WHERE
orLIMIT
clause) that contains sub-queries, or when you run a query that includes BLOB-type fields. I'll use this issue to add an optional prompt for when you run an unconstrained query even if it doesn't include sub-queries.