I've faced with the following problem during development of middle+ size application:
When user select the specific value(s) in the list, for example, set of months ( a Qlikviewfield in Master calendar) - there is a delay in 15-20 seconds BEFORE QLIKVIEW STARTS TO RECALCULATE OBJECTS (object recalculation does not consume so much time = 2-3 sec). During this delay, all 16 cores of CPU are loaded up to 100%.
Details: QlikView 12.1 SR4, QVW size – 4Gb, 180M records х 80 fields in fact table, Star Schema (+10 Dic tables)
Environment (Virtual): x64 WinServer 2012R2, 128 Gb RAM, 16 CPU (logical) cores AMD Opteron 6174
I’ve done and checked a lot in order to optimize performance:
I realize, the App is not simple and requires much CPU resources for processing, but the most of all I consider of DELAY between SELECTION and the start of object recalculation (EVEN IF THERE IS NOTHING TO RECALCULATE – ONLY LISTS ON SHEET).
Of course I think that hardware tuning could help – physical vs. virtual, Intel vs. AMD, disable NUMA. But not significantly …
Does anybody know what could cause the described delay in the associative model performance?
Thanks in advance!