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!