Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Append Blank or Insert Into?
Message
De
16/09/1998 02:42:12
 
 
À
14/09/1998 22:38:23
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Divers
Thread ID:
00136359
Message ID:
00137155
Vues:
41
>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.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform