Issue with rand fn (increase size of qvd)

[#1]

Hi, I have a qvd which is currently 1.4 GB in size.

I want to increase the size of the qvd to close to 5 GB

These are my fields:

Load Country,

          DATE,

         Count_of_sucess,

         Product

from C:\Desktop\Sample.qvd(qvd);

To increase the size I used rand function

Load Country,

          DATE,

        Round(((rand()*(0.25-0.15))+0.15)*Count_of_sucess) as Count_of_sucess,

         Product

from C:\Desktop\Sample.qvd(qvd);

But it didn't work I tried using autogenerate 10000 but it is giving me error.

Any help much appreciated.

[hector_munoz]

Hi Adi,

Try the following:

FOR vsContador = 0 TO 3

T1:

Load Country,

          DATE,

        Count_of_sucess,

         Product

from C:\Desktop\Sample.qvd(qvd);

NEXT

It will load the QVD 4 times in table T1 and you will have a total size of 5.6 GB.

Hope it serves.

Regards

H

[#3]

Hi Hector,

Thanks for the quick response. I'm doing this exercise to test out the performance of my qlik application which is using this qvd.

If we load the same data n times, it would easily get compressed and that won't be a genuine way to test the performance right?

[hector_munoz · Accepted solution]

Maybe,

Then you can try to add years to DATE (e.g. Date(AddMonths(DATE, 12*$(vsContador)) AS DATE), mutiply Count_of_success by a rand() as you where doing and invent some aleatory Products...

Regards,

H