topic Need Clarification on Datamodel in QlikView

Need Clarification on Datamodel

Nagaraju_KCS — Fri, 18 Sep 2015 05:48:17 GMT

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........!!

Re: Need Clarification on Datamodel

tresB — Fri, 18 Sep 2015 05:55:41 GMT

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.

Re: Need Clarification on Datamodel

Kushal_Chawda — Fri, 18 Sep 2015 05:57:56 GMT

see below link

https://community.qlik.com/blogs/qlikviewdesignblog/2015/01/19/number-of-hops