I have developed a custom report but the data fetching at the time of browsing is taking a huge time. I have also monitor that at time of execution, the CPU and memory has taken above 90%.
My question is that what the point I should take care to perform the report execution fast. My application size is 1.20 GB.
You need to provide more details, like number of records and columns, the script and screenshots from tableviewer, your system environment (desktop client, server - access point, 32-bit OS ?) and by which actions you have a huge time needed (and how much is huge and what do you expect ?).
You mean with local client the desktop client which opened the application directly without using the server, right? Then I think you haven't enough RAM (I assume in regard to your number of records that your application size is measured in a compressed mode - take a look on the document properties in tab general in the top left area - if you stored it uncompressed you will see the real RAM footprint without the amount needed to cache the result of your interactions) and qlikview will be permanently swapping into the virtual RAM on the hard-disc - and this will be very slow.
