Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Which approach is better?
Message
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
Which approach is better?
Divers
Thread ID:
00808727
Message ID:
00808727
Vues:
60
i have a program that send records to the server in batch
my code looks like this. it it assumed the tables ( table1 ... table50) contains only the transactionof the day.
i want to know hick approach is better


approach 1:
begin trans
sele table1
scan
insert into servertable1 from memvar
endsca
.
.
sele table50
scan
insert into servertable50 from memvar
endsca
end trans

approach 2:
or i have to break this down one transaction per table

begin trans
sele table1
scan
insert into servertable1 from memvar
endsca
end trans
.......

begin trans
sele table50
scan
insert into servertable50 from memvar
endsca
end trans

thanks for the advise!
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform