Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Append blank VS insert SQL
Message
From
23/03/2005 14:58:57
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00998018
Message ID:
00998597
Views:
44
>>>>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.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform