Middleware --- polling or triggering

Hi there,

I am studying which way is the best to refresh the DB. There are two DB and let say A and B, they are in different machine. When the update is done on A, then we need to refresh the corresponding table in B. Now let's assumed that the db_link can't be used. we are just thinking of two approaches

1. to set the timer in middleware to periodically do the synchronisation between the two DB.
2. to setup the trigger in DB A, any update in A will be firing a trigger to update B.

Is there any whitepaper or document in comparing this two approach ? Should you have any other alternatives, kindly drop a few words also, many thanks.

Ken Received on Tue Aug 31 1999 - 12:15:16 CDT