Hi Friends,

I'm confused about which commit is better:

Say I have two sites A & B connected with WAN 256KB. Site A has table LOANS_PAYMENT TABLE which has a replica on B. The requirement is that
once a payment record is inserted in site A in will be immediately replicated to B as soon as possible. The payment table has a daily transaction insert of
10,000 rows and average legth of 50 bytes per row.

Option 1:
create db trigger(after insert) on LOANS_PAYMENT in site-A to insert on
site B

Option 2:
Create repliction view refresh fast on commit.


My question is, which is effective and effecient program? a db trigger
or a replication refresh.

Thanks a lot