RE: Trigger in Replicated Database [message #75074] |
Mon, 23 July 2001 05:52 |
francis
Messages: 4 Registered: July 2001
|
Junior Member |
|
|
Could someone tell me if there would be any issues using a trigger that performs an update on a table in a production database that is replicated every 5 minutes?
The replication database is used for reporting purposes and no DML statements are ever performed on it. Thanks in advance.
----------------------------------------------------------------------
|
|
|
Re: RE: Trigger in Replicated Database [message #75078 is a reply to message #75074] |
Thu, 26 July 2001 20:06 |
andrew again
Messages: 2577 Registered: March 2000
|
Senior Member |
|
|
5 minutes could be a bit short unless you have lots of network bandwidth (depending on the volumnes of changed/new/deleted data too) and spare capacity on both machines.
----------------------------------------------------------------------
|
|
|