Hi Pat,
Remember this.
APPEND BLANK, REPLACE, REPLACE - Very slow, CDX may need to be updated 3 times.
INSERT INTO - Better, CDX only is updated once per record. Still a lot of network traffic in that a CDX lock and a DBF Header lock are needed for each record inserted.
APPEND FROM - Best since DBF Header is locked only once for all records. CDX update may occur only once as well. I don't know this is true, but it would may sense since no other user would even know the new records exist until the append has completed and the DBF header is unlocked.
If you can use the Table exclusively, so much the better.
>I have a form that is reading data from several text files and inserting it into tables. It has been running for 26 hours so far. I have a wait window that is showing me a counter. I have noticed that it is getting slower and slower the longer it runs.
>
>Is there anything I can do to prevent it from slowing down?
>
>Thanks
>
>Pat Murphy
Charlie