Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
any more helpfull answer please reply
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.
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.
thanks Nils !! Noted very helpful of course.
anant
noted. Santhosh Thanks !!
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.