-
Type:
Improvement
-
Resolution: Unresolved
-
Priority:
Major - P3
-
None
-
Affects Version/s: None
-
Component/s: None
-
None
-
Query Execution
-
None
-
None
-
None
-
None
-
None
-
None
-
None
pcre2 regexes can have an extra JIT compilation step that can improve performance of matching the regex.
The cost is two-fold: more RAM for the pattern and more time spent "compiling" the regex.
However, benchmarks show significant improvements up to 50% on micro-benchmarks that focus on regexes and up to 40% for real queries.
Compilation time penalty can be avoided by having a cache of pre-compiled regexes.