2 Replies Latest reply: Jul 23, 2013 3:58 AM by Дмитрий Кудревич RSS

    growing data size with RAND()

      Hi.

       

      I was trying to reload Data from my qvw-file(150Mb) with Binary for making a new Demo.qvw.

      I was decided to recalculate Data values with *Rand(), but after reloading my new Demo.qvw have +130Mb size.

      Numbers of rows(24 000 000) and tables the same. Structure the same. Only fields value differ.

      I tested on the other files, results the same.

       

      Why?

       

      BINARY [Data.qvw];

       

       

      table_1_demo:

      NoConcatenate

      LOAD

      Country,

      Dept,

      Value*Rand() as Value

       

      Resident table_1;

      DROP table table_1;