>>>>Discovered something that folks might find useful.
>>>>
>>>>If you need to append records from one table to another based on a condition you would think (as did I ) of using the command
>>>>
>>>>Append from (sourcetable) for mycondition
>>>>
>>>>WRONG.
>>>>
>>>>Instead do the following
>>>>
>>>>Use sourcetable
>>>>scan for mycondition
>>>> insert into destinationtable (fields) values (sourcetable.fields)
>>>>endscan
>>>>
>>>>Apparently append from doesn't use rushmore and the benchmark difference between the two, even on medium tables (source 10,000 records, dest 1,000 records) was staggaring.
>>>>
>>>>HTH
>>>
>>>VFP help contains list of Rushmore Optimizable Commands ("Potentially Optimizable Commands with FOR Clause"). It includes SCAN and misses "APPEND".
>>
>>But THAT involves 'RTFM' and we all know programmers NEVER do that ;-)
>>
>>Barbara
>
>What is 'RTFM'?
Read the [expletive deleted] Manual.