Thanks for responding.
Yes, its full browser application and when clicked on app link, it opens with opendoc.htm as below-
On 2nd one, I should have written that when opened from qlikview developer in server machine, it works as normal.
When I make few selections to reduce data set, it works as desired.
With no selections, even clicking in time period list box with 20-30 entries takes more than 30 secs.
When no filter is selected or not enough filters are selected, and when I switch metrics between Sales and Margin(metrics/measures are dynamically applied through island tables), it takes same amount of time(No caching it seems?), that gives me some indication whether its doing paging and result-sets caching is not working.
With 98 GB total RAM and 65-70 GB RAM usage in task monitor, looks like there is enough for cache. Working set limit is set as default(70-90%)
The stats you posted show an atypically large number of tables and objects. I would begin by running Document Analyzer
and see if you can eliminate unnecessary data and find some high-calc or high-memory objects to focus on.
I'm surprised that it doesn't perform poorly in the desktop as well. I have seen some apps with high numbers of objects perform slower in the server than desktop, I'm not sure the cause.
The cache observation is interesting. Are you using any data islands? Lot's of variables with "=" signs? Does your QV Server have enough RAM?