Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
TABLE BUFFERING OR SCATTER GATHER? ADD RECORDS IN THE TA
Message
De
08/06/1996 04:01:01
 
 
À
07/06/1996 17:05:28
Francois Liboiron
National Bank of Canada
Montréal, Québec, Canada
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00002014
Message ID:
00002091
Vues:
40
>Thank you Arnon Gal-Oz, it is the second time you
>help me, I appreciate.
>
>Did you look on the on line Help on the section
>performance hint?? It is write that INSERT SQL is
>faster than a append blank.

i know but when u add a single record at a time it
doesn't matter that much (IMO) -
if u are makeing a large update defenetly use INSERT SQL

>If I interstand, you mean that with buffering on,
>append blank,
>does not add the record in the table immediatly,
>just when you
>write TableUpdate and you can revert the change in
>the buffer with TableRevert().

yes, that's what buffering is for.
usually u would want to use one of the optimistic buffering
methods.

>How did you check that before a
>tableupdate/tablerevert they have negative record
>number?
i didn't have to - it is well documented in the manuals

>Could you explain me, wath you mean by "RI code"

RI - Relational Integrity , in this particular case
the append trigger

>I hope I will be able to speak to you again(excuse
>my bad english!!!)

ces ne pas des problem (spelling ?)
- after all English is not my primary lang. as well :)



Arnon
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform