>>Not correct, the DBF & FPT individually have a 2Gig limit i.e. total 4Gig between them, as for the CDX I would have to check, but I think it also has an individual limit of 2Gig.
>
>What I meant is that since the FTP will reach that limit first, and years before the DBF and CDX, I only have to worry about this one for now. My approach was to remove that field from the DBF in order to not be bound to that restriction. Then, I could have about 1 Gig in each of the FieldMemoX.dbf table which would hold the memo field values of all the records of Table.dbf.
I think it's a good idea to move Memo field into a separate file. We discussed this idea while ago among our developers group and I don't remember why didn't go for it...
If it's not broken, fix it until it is.
My Blog