DBT-file growing very large, why??

[Guest_imported]

my problem is that the DBT-file is growing to very large sizes.

are the memo-fields of deleted records are removed at PACKing or not??
it seems to me that they arent.

The dbt gets small again when doing a COPY TO.

Is this the only way?
peter

 

[TonHu]

Well, dbt blocksize is quite large, and it is *not* shrunk on a pack as well. You'll have to use:

copy all to tmp
use
rename 'file.dbf' to 'old.dbf'
rename 'file.dbt' to 'old.dbt'
rename 'tmp.dbf' to 'file.dbf'
rename 'tmp.dbt' to 'file.dbt'

done.
Could also use DBFCDX driver, and convert to FPT memofiles, it uses much smaller blocks, re-uses old space if it could fit, and uses compression to store the file (I was told, not sure about the last feature)

HTH
TonHu

 

[arcsoft]

Yes the advice given already is true, use DBFCDX driver it compacts the size of the MEMO database.

I was having problem with the dbt's when file size was going very high, around 33 mb.

On use of DBFCDX driver the new FPT file was created with just 5 mb in size.

start using the dbfcdx driver.

ketan patel.

 

[Guest_imported]

Thanks a lot, your answer helped me.

Peter