QVW Applcation Size Management

[Anonymous]

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

[#2]

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

[#3]

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

[Anonymous]

any more helpfull answer please reply

[#5]

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.

[Anonymous]

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.

[Anonymous]

thanks Nils !! Noted very helpful of course.

anant

[Anonymous]

noted.  Santhosh Thanks !!

[#9]

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.