Page 1 of 1

DataSet against Sequential file

Posted: Tue Mar 06, 2007 10:34 pm
by videsh77
Just a Qn when I checked DataSet as against Sequential File. I found file size in unix env for DataSet is greater than Sequential file. Is it normal to have DataSets remain bigger in size than Sequential file for the same Data contents?

Posted: Tue Mar 06, 2007 10:43 pm
by kumar_s
Yes, dataset has its own conversion algorithm.
And more over the fields like varchar are assigned the full length of its max value. In order to improve the access efficiency. Where as sequential files will have the whitspace truncated.

Posted: Tue Mar 06, 2007 10:47 pm
by videsh77
Thanks it helps.