Performance of wildcard

General Rules
1

What is the name of the domain?

N/A

What is the issue you’re encountering

Comparing wildcard with concat()

What steps have you taken to resolve the issue?

@ncano Do you have data on the relative performance of wildcards vis-à-vis the concat() function?

2

Hey, thanks for your question!

The concat() function and the wildcard features (wildcard, wildcard_replace()) serve very different purposes. concat() is designed for string concatenation and is very fast, as it simply joins byte strings together.

On the other hand, wildcard operations like wildcard and wildcard_replace() involve pattern matching, which makes them generally slower compared to concat() because they have to process and match patterns across inputs.

1 Like
3

This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.