Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Append Blank or Insert Into?
Message
From
16/09/1998 02:42:12
 
 
To
14/09/1998 22:38:23
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00136359
Message ID:
00137155
Views:
43
>Hi David ----
>
>>In addition to other coments, APPEND BLANK has a performance penalty; the index(es) have to be updated twice. INSERT INTO does a single index update, which means it's *about* twice as fast.
>>Unfortunately there's no INSERT INTO FROM NAME objectname, which would be nice since they introduced SCATTER NAME objectname.
>
>Ahhh, but there is a GATHER NAME :-)
>Thats the compliment to SCATTER NAME.

That's right, and that's what I use from time to time. Now that Jim B has explained that APPEND BLANK/GATHER NAME has no performance penalty in a buffered environment I'm a much happier little beaver.
Previous
Reply
Map
View

Click here to load this message in the networking platform