topic Re: QVW Applcation Size Management in QlikView

QVW Applcation Size Management

Anonymous — Mon, 13 Jan 2014 06:38:48 GMT

Hi All,

Want to know how to manage a common problem in QVW application

as we know when records increase in data base say transaction table and daily there is lakh of records

punch in we see a increase in size of QVW application it increase let say from 300 mb to 600 mb then 1 gb and 10 GB

and sometimes it do not open on clicking or in access point?

so want to know what are remedies to avoid such situation and what planning is required to be done

so as to avoid such scenarios?

anant

Re: QVW Applcation Size Management

Mon, 13 Jan 2014 07:07:06 GMT

Hi Anant,

Some tips.

1) Remove unnecessary fields and data from application. I mean comment it whichever is not usefull.

2) Try to Avoid the complex logic at chart level and if condition in charts and front end.

3) Create a Memory Statistics file(.Mem) from Document Properties and then load this into QV Optimizer then you will know each and every Field, Object, Table and variable is taking the memory then you can decide what to do with that.

Santhosh G

Re: QVW Applcation Size Management

Mon, 13 Jan 2014 07:16:30 GMT

When you could see, there is very slow response time or similar issue from the users. you could think the most important/Top Matrices and create document chaining to handle the application.

-Lalmohan

Re: QVW Applcation Size Management

Anonymous — Mon, 13 Jan 2014 07:39:02 GMT

any more helpfull answer please reply

Re: QVW Applcation Size Management

Mon, 13 Jan 2014 07:49:14 GMT

Try to load the data into QVD then load the data from Qvd to your main application(.qvw).

This will not only reduce the size but also Fast retrieval of data is accomplished.

Re: QVW Applcation Size Management

Anonymous — Mon, 13 Jan 2014 08:08:28 GMT

Hi,

I would also look into the possibility of reducing the amount of periods showing in the document. Maybe split the document into two files with one containing old data and the second containing newer. I don't know how much you have stored historically but unless needed only try and keep the period you actually use on a daily basis maybe last year or last 3 years.

Re: QVW Applcation Size Management

Anonymous — Mon, 13 Jan 2014 08:11:09 GMT

thanks Nils !! Noted very helpful of course.

anant

Re: QVW Applcation Size Management

Anonymous — Mon, 13 Jan 2014 08:12:21 GMT

noted. Santhosh Thanks !!

Re: QVW Applcation Size Management

Mon, 13 Jan 2014 11:14:03 GMT

Try to load the data into QVD then load the data from Qvd to your main application(.qvw).

This will not only reduce the size but also Fast retrieval of data is accomplished.