topic Re: which one is better in performance wise? in QlikView

which one is better in performance wise?

Anonymous — Sun, 26 Apr 2015 06:45:26 GMT

Among join and concatenate

which one is good

as per my knowledge is concatenate is better ?

Re: which one is better in performance wise?

mohamed_ahid — Sun, 26 Apr 2015 11:36:02 GMT

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 .

Re: which one is better in performance wise?

marcus_sommer — Sun, 26 Apr 2015 15:06:01 GMT

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