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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Nagaraju_KCS
Specialist III
Specialist III
‎2015-09-18 01:48 AM

Need Clarification on Datamodel

HI Community,

Application1

I have 10 tables, I have done all calculations and manipulations, i have made one datamodel (StarSchema).

and

Application2

same tables,  i have one more datamodel, but i did ETL process here... just i have made one table..

Now My Question is.............   Which datamodel is fast???

Application1 or Application2 ...    (in both Applications same calculations)

Thanks in Advance........!!

Labels (1)
Labels
418 Views
0 Likes
2 Replies
tresB
Champion III
Champion III
‎2015-09-18 01:55 AM

In brief,

If data size is very big, the single table would perform a little better in the front-end (assuming set analysis would be used in the front-end expression). However, that would trade off in the back-end to take more time in reload and probably server RAM consumption would go high too during load. And this is assuming that, the single table conversion has been done in optimum way.

300 Views
0 Likes