QlikView Maixmum to save the QVD

[#1]

Good Evening All,

As we are stroing the QVD's in a folder and One QVD size of 1.6 GB when I reload its not able to save in the server folder, when I run with minmum data that time I can save the QVD in the same folder.

We are using Xeon (X5670 @5.93 GHz (2 Processors) with a memory of 5 GB.

My question is that any memory problem to store 1.6 GB in a folder.

Looking for your valuable suggestions...

Advance Thanks

Joe

[erichshiino]

Maybe your application became too big for the memory when trying to store the QVD.

You could break the whole table into smaller pieces and store the data into many qvds instead of a big one.

After this, you could load all of them using a wild character Something like:

load * from table*.qvd(qvd);

To store your table into separeted qvds, you can use a code like this:

TABLE:
LOAD * INLINE [
    OBJECT, VALUE
    A, "123,456"
    B, 1234
    C, "136,1532,16323"
]
;
control:
load Distinct OBJECT AS CONTROL_FIELD
resident TABLE;
LET vRowCount = fieldvaluecount('CONTROL_FIELD');
Trace vRowCount = $(vRowCount);
FOR i = 1 TO $(vRowCount)
          Trace i=$(i);
          LET vLoopValue = FieldValue('CONTROL_FIELD',$(i));//Peek('FileNameA',i,'BaseDataFilenames');
          NoConcatenate
          Reduced_Table:
          Load * resident TABLE
          Where OBJECT = '$(vLoopValue)'
          ;
          Store Reduced_Table into [Table$(vLoopValue).qvd];
NEXT