Information générale
Titre:
Which approach is better?
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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement