>>>>and what about speed ?
>>>>I made a test and seems like append was 4 to 10 times slower
>>>It has been a long time I don't use 'Append Blank'.
>>
>>I'd only add one more thing: since the table is very likely to have indexes, the indexes need to be updated too. With append blank, we're writing blanks into the fields and indexes, then during a replace we're doing it again (and potentially reshuffling some of the b-trees in some of the indexes). So it's not one write vs two writes, it's n writes vs 2*n writes.
>
>Hi.
>I believe i read in the Help that when buffering is on it is adviseable to use Append Blank, Replace construction. Is it still true, or Insert is OK across the board?
Can't find that in help - and with buffering you are actually delaying the write until tableupdate(), so the difference between the two actually vanishes. VFP only has more work to do with its buffers meanwhile, if you append/replace.