How to further reduce the file size ? Yet still can select CY or CYTD

[paulyeo11]

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

[marcus_sommer · Accepted solution]

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

[#3]

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.