Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi , my enviroment is 96 GB , 16 core cpu
and my application is 170 MB , 32 M records with 60 fields using a RAM of around 830 MB
data model is just 2 tables linked with one field and pulling these tables from stored QVD.
when I just do a selection in given list box or chart ...cpu usage is raising to 100% (in fraction of sec coming to 67%) and
in performance tab of task manager all the crore peaks are giving significant peaks at 100%
my question is is it normal to take 100% cpu ? the performance of dashorad is very slow .
what is the solution for this ? I Have already seen the list of best parctices and i'm following those ...
here is the scrren shot i couldn't it at 100 because it's changes in fraction of second from 100- 98.
coming to expression there are abit complex with variables ...
but i don't undertsand is
i'm using qvd for puling the data ...
.and my app size is only 170 MB
but my server is big of 96 GB with 16 cpu
which it is consumiing this much CPU
Sri
Nick is right, you're problem is the same as mine although my model is
more complex, the issues are the same, QlikView is simply trying to do
too much when calculating. You say your expressions are "a bit complex
with variables" well this is the first place I'd look, try to simplify
your expressions by moving as much of that into the load script as you
can.
Post a sample of one of your complex expressions, just so we have an
idea of what you're doing.
Nigel.
also, take a look at this doc, hope it's useful for you.