7 Replies Latest reply: Nov 13, 2013 7:58 AM by Ralf Becher RSS

    why qvd size is almost the same no matter if you optimize the content of the fields??

    HECTOR GARCIA

      hello I'm trying to optimize my data model replacing the content of a long string field for  a numeric value field, but when I store and compare the output the size of the qvd is almost the same , any body now why???graph1.jpg

      This is my table.

       

      This my script:

      data:

      LOAD floor(num(EVENTID)) as EVENTID,

             mapingid3,

             autonumber(mapingid3) as mapignum

      FROM

      \\qlvpublisher01\G\SourceDocuments\DataSources\QVDs\BCO\Bolp\HIST\2013_11_09_eventosbco.qvd

      (qvd);

       

      store EVENTID,mapingid3 from data into conmapping.qvd(qvd);

      store EVENTID,mapingid3 from data into conmapping.txt(txt);

      store EVENTID,mapignum from data into conmappingnum.qvd(qvd);

      store EVENTID,mapignum from data into conmappingnum.txt(txt);

       

      this is the resulting qvd's looks: if i'm replacing the content of a big string for a integer, i'm expecting a significant reduction of the qvd size, but this is not happening why??? any body can help me to understand??

       

      this is the way the qvd files