Description
The regular expression patterns used for attempting to parse exec and call SQL statements are extremely complex. For large query sizes, executing the regex on those statements can take a very long time. A customer had a 48k SQL statement that went through these regexs and it took almost 2 minutes.
We need a new config to disable the running of these patterns. Potential config:
common: &default_settings
transaction_tracer:
# For large SQL statements, executing the regular expressions that attempt to parse exec and
# call statements can take a significant amount of time. Setting this to true will disable the
# execution of these complex regular expressions.
# Default is false.
exec_call_sql_regex_disabled: false
If this is set to true, we would skip the execution of those 2 problem expressions.
DefaultDatabaseStatementParser patterns
GTSE