Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

performance between RegEx and TFileInputDelimited

I found that tFileInputRegex is better than a tFileInputDelimited to do a join.
i don't understand why it's better. Is it always true or not ?
Labels (2)
5 Replies
Anonymous
Not applicable
Author

Hello,
Do you mean that tFileInputRegex is faster than tFileInputDelimited ?
Regular expressions are pretty fast, but it also depends on various proerty like options selected in your tFileInputDelimited, your keys, your data types and on your files.
You post seems interesting, what is the gap between the two jobs ?
Regards,
Anonymous
Not applicable
Author

i have same structure on two components and time is better for x4 with RegEx.
Anonymous
Not applicable
Author

With your regular expression, we can see that you don't use the CSV options.
This option is really time-consuming.
You should deactivate it to accelerate your tFileInputDelimited components.
Regards,
Anonymous
Not applicable
Author

I test without csv option and now job is done in 13 minutes (20 minutes before). It's better but not really very good because there's only 1 million lines.
Anonymous
Not applicable
Author

Can you post your final job ?