Discussion Board for collaboration related to QlikView App Development.
Which one gives better peformance for large data set .
Link Table with multiple fact tables
One concatenated fact table with multiple columns
Also i have observed that the second option increases the size of qvw application . is it fine ???
please refer Concatenate vs Link Table by amz
Ankur i have read that pdf .
Just wanted to understand from people in community from their real time experience in their respective project on this scenario.
I have used second option in my project and found slight lag while reloading the data
What about the performance of your dashboard . I have also used the second option and found it improving the performance of dashboard but the file size increased by way too much
File size was a concern for me too.. it increased drastically.. However performance was slightly improved
Only concern for me was the file size and reload time