topic Re: QlikView Access point performance in QlikView

QlikView Access point performance

Fri, 03 Aug 2012 14:56:34 GMT

Hello Everyone,

We are facing a performance issue when sharing our files on Access point . I want to ask , is this because of the size of qvw files we are sharing on Access points or something to do with the Data model? For example , we are sharing a qvw file 2 gb big .when someone try to open it , it takes about 10 mins.Is there anything we can do in QVS web server to optimize or reduce the opening time on access point ??

and the other scenario is if we have data model with only two tables each having size of 5 gb.and we need all the data so cannot perform silicing to achieve correct results based on our calculations.What we should do in that case?

Any suggestions?

Regards,

Salman

Re: QlikView Access point performance

Anonymous — Fri, 03 Aug 2012 15:01:59 GMT

can provide these details so that it's help to answer

what is your plugin..

how big is your RAM

how many concuuurent users

Re: QlikView Access point performance

Mon, 06 Aug 2012 07:20:13 GMT

hi srikanthsri1

Plugin is IE and Ajax zerofootprint client

Ram is 34 gig

Concurrent users at most for this doczment are 4

Regards,

Salman

Re: QlikView Access point performance

Anonymous — Mon, 06 Aug 2012 07:31:18 GMT

Have you tried preloading the document on the server to make sure it's loaded in RAM at all times. This should speed up client access on initial opening.

I would also recommend going through the document using the various techniques you can find around these forums and check for potential performance problems in your data model and front end.

Re: QlikView Access point performance

Mon, 06 Aug 2012 07:36:07 GMT

thanks Johannes Sunden for your reply.By preloading document into memory will not eat memory all the time? even when this document is not in use?