topic Re: How to reduce the time when app open on server in QlikView

How to reduce the time when app open on server

Wed, 01 Oct 2014 04:58:55 GMT

we have increased the ram from 127 GB to 256 GB, but still it takes time to open,when user want to open an application on production

Do we have to increase the paged memory also or something elsa

Re: How to reduce the time when app open on server

Wed, 01 Oct 2014 06:34:47 GMT

If you have big documents that needs to be accesses by several people on a regular basis would I recommend that you look into pre-loading the document in QV server alt looking into split the app into smaller docs, dived by task/focused area.

Re: How to reduce the time when app open on server

ashfaq_haseeb — Wed, 01 Oct 2014 06:38:59 GMT

Yes

Try be checking preload.

go to QEMC--> Documents --> user Documents --> Select your document --> Select your Application --> go to server tab on righ pane --> Performance tab --> Select preload.

Let me know if that helped.

consider optimizing application if you can, to improve your application performance.

Regards

ASHFAQ

Re: How to reduce the time when app open on server

Wed, 01 Oct 2014 06:39:37 GMT

spliting is already implement ,even i have taken the binary in its GUI application

Re: How to reduce the time when app open on server

ashfaq_haseeb — Wed, 01 Oct 2014 06:43:06 GMT

If you have heavier calculation in front end try to move that to back-end.

Regards

ASHFAQ

Re: How to reduce the time when app open on server

Wed, 01 Oct 2014 06:54:46 GMT

suppose I have use this exp in a chart

= num((SUM({<FiscalYearName={'$(vFCY)'},FisQuarter=,FiscalMonth=>} IF(Date<= vMaxDate,DailyAOPSales))

SUM( {<FiscalYearName={'$(vFCY)'},FisQuarter=,FiscalMonth=>} If(Date < vMaxDate,DailyAOPTransaction_2)))

,'###0')

how we can move it to back end