Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

which one is better in performance wise?

Among join and concatenate

which one is good   

as per my knowledge is concatenate is better ?

1 Solution

Accepted Solutions
marcus_sommer

I think there isn't a "better" performance for this way or that way. It will be depend on the structure and amount of your data-sources and what you want to perform within the gui and then what will be your biggest bottle-neck in your hardware- and system-ressources. This meant you could optimize your app regarding to app-size or load-time or complexity or calculation-times or .... Have a look here to different approaches:

To Join or not to Join

Mapping as an Alternative to Joining

Concatenate vs Link Table

Merging Data from Multiple Sources

Data Modelling: Clarity vs. Speed

- Marcus

View solution in original post

2 Replies
mohamed_ahid
Partner - Specialist
Partner - Specialist

for me join is perf consummer just  while loading ,concatenate is less .also i think that when you concatenate certainly you will have duplicated values and automatically you application will be more huge in terme of size (it depends on data).

basically using one of the two method  depend on every situation .

marcus_sommer

I think there isn't a "better" performance for this way or that way. It will be depend on the structure and amount of your data-sources and what you want to perform within the gui and then what will be your biggest bottle-neck in your hardware- and system-ressources. This meant you could optimize your app regarding to app-size or load-time or complexity or calculation-times or .... Have a look here to different approaches:

To Join or not to Join

Mapping as an Alternative to Joining

Concatenate vs Link Table

Merging Data from Multiple Sources

Data Modelling: Clarity vs. Speed

- Marcus