Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Which one gives better peformance for large data set - Link Table with multiple fact tables or one concatenated fact table with multiple columns

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 ???

6 Replies
Not applicable
Author

please refer Concatenate vs Link Table by amz

Not applicable
Author

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.

Not applicable
Author

I have used second option in my project and found slight lag while reloading the data

Not applicable
Author

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

Not applicable
Author

File size was a concern for me too.. it increased drastically.. However performance was slightly improved

Not applicable
Author

Only concern for me was the file size and reload time