topic Re: Star schema is better in Script Run time in QlikView

Star schema is better in Script Run time

Anonymous — Sat, 10 Sep 2016 22:32:25 GMT

Response time is good in Star schema which I can understand (in the calculation process because of too many joins slows down the response time)

But it also says Script run time is excellent in Star schema but good in Snow Flake. Can some one please provide an example for this statement why the script run time is excellent in Star schema?

Re: Star schema is better in Script Run time

ToniKautto — Sat, 10 Sep 2016 23:10:12 GMT

Can you clarify where the image comes from?

I assume measurements like this are based on actual data, so it would be easier to evaluate the conclusion if the context is known.

Re: Star schema is better in Script Run time

Anonymous — Sat, 10 Sep 2016 23:26:56 GMT

"Qlikview Best Practice Guidelines Development". If you search in google with this text, you get a qlikview community link. From that, I have downloaded this document.

Re: Star schema is better in Script Run time

ToniKautto — Sun, 11 Sep 2016 02:46:29 GMT

Please provide the direct link, so that we are sure to be looking at the same PDF.

Re: Star schema is better in Script Run time

Anonymous — Sun, 11 Sep 2016 03:36:37 GMT

Best Practices for Data Modelling

I got the document from this forum

Re: Star schema is better in Script Run time

marcus_sommer — Mon, 12 Sep 2016 07:53:37 GMT

These table comparing various approaches to build a datamodel is a simplification and it will always depend on your real data which approach is more suitable - and quite often you will have no pure datamodel in this or that direction - they will be rather a mix.

Nevertheless the statements of this table show in the right direction.

I think the difference between good and excellent in the script run-times will be caused through the efforts to create the necessary link-table(s) which are additionally in this case.

- Marcus