>>>>>What can be done to allow an append, from a large delimited text file, to proceed at optimal speed?
>>>>>In some environments, my append slows way down.
>>>>
>>>>Use Local destination table/cursor w/o indexes
>>>
>>>Also you should run your .EXE at client's own HDD, not a server's HDD from client.
>>
>>I agree with Sergey. The location of the exe won't affect the speed of append from. However, for the same reason that a local exe is better than a remote one, it will be faster to append to a local cursor.
>
>That is only true if the cursor is not materialized (yet)
>
>If FILE(DBF("MyCursor")) returns .T. the cursor is flushed to disk. Then there is no difference between a cursor and a (local) DBF.
But still a huge difference between local disk and one on the network. And if the local disk is a SSD...