Hi Marcos, Yes, this can easily happen. Consider, as a thought experiment, an extreme case in which a database has a single record, with a text field which is edited 100 times. Each new value placed into the text field will cause the TXX file to grow. But, since there is only one record, after export/import, the TXX file will be about one percent of its top size. I hope this thought experiment helps to give you confidence that the TXX file can shrink considerably. Comparing CSV files before and after is the best way to be entirely sure that there is no data loss.
Best wishes, Bruce On Mon, Sep 3, 2012 at 8:11 AM, Marcos Favero Florence de Barros <[email protected]> wrote: > Hi, > > I know from Ralph Alvy's book that a TXX file can shrink, for > instance during a "big clean". > > I did a similar export/import (to change the structure), and the > TXX file was reduced to *one-third* of its original size, going > from 790 to 240 kB. > > Apparently there has been no loss of data. I tested that by > comparing CSV files of the panels containing variable-length > text fields before and after the export/import operation. > > But, just to double-check it, I'd like to know whether such > massive size reductions are normal. > > Regards, > > Marcos > > > -------------------------------------- > Marcos Fávero Florence de Barros > Campinas, Brazil > > > _______________________________________________ > Dataperf mailing list > [email protected] > http://lists.dataperfect.nl/mailman/listinfo/dataperf _______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
