I don't see the need at all to buffer the records when you are trying to do a large archive. Is this in VFP tables? Or remote tables? Does the storage of records need to be transactionalized?
>Hi,
>
>I'm working on a mechanism that is going to archive a couple of large tables. (you may have read my question from yesterday) A tremendous amount of records would be tableupdated at the same time. I saw somewhere else in our software a developper was commiting the buffers every 100th record. That developper no longer works here so I can't ask him about it. Would it be a good idea for me to do something similar? Also, why would it (or not) be a good idea to do it that way? We are using VFP 6 with VMP (version 4) framework.
>
>Thanks,
>Chris
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown