Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
My actual QV sample file size is quite big = 17 Mb.
Binary "C:\Users\Paul Yeo\Dropbox\0_Q_Development\QV4QS\QV4QS_V041e.qvw"; // Load QV4QS
After i add the below script , the file size reduce to 8.4 Mb
NEW:
NOCONCATENATE
LOAD *
RESIDENT sales WHERE BRAND_='HAKKO';
DROP TABLES sales;
NEW:
NOCONCATENATE
LOAD *
RESIDENT MasterCalendar WHERE year>'2013';
DROP TABLES MasterCalendar ;
My Question :-
it there any other methode which i can further reduce the file size ?
Pls Take note that i can use reduce data -> keep possible value. As i need to select box 1
Paul
You could check your app with the Document Analyzer update 2.7 and look if you could reduce high cardenality fields: The Importance Of Being Distinct.
- Marcus
You could check your app with the Document Analyzer update 2.7 and look if you could reduce high cardenality fields: The Importance Of Being Distinct.
- Marcus
You can consider below to optimise the QVW
1. Try to avoid Synthetic tables where possible
2. Comment the unwanted/unused columns & tables from the data model.
Hope this helps.