Do not analyze files larger than N lines
For suggestions, auto-complete, and code analysis, very large SQL scripts cause excessive latency and can crash SSMS.
Please add an option where a file that is longer than N lines will not be automatically scanned/validated.
Use-Case: Complex database build scripts, schema source files, or other scenarios where a script can be tens of thousands of lines long require me to disable SQL Prompt before opening. Failure to disable SQL Prompt results in minutes of excessive latency and the inability to move the mouse around easily, type, or take any actions. This often leads to crashes, as well, either of the SQL Prompt service or of SSMS itself.
Thank you!
1
vote
Edward Pollack
shared this idea