Home » Server Options » Replication » RE: Trigger in Replicated Database
RE: Trigger in Replicated Database [message #75074] Mon, 23 July 2001 05:52 Go to next message
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 Go to previous message
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.

----------------------------------------------------------------------
Previous Topic: changing the sequence number of replicated data
Next Topic: Problem in first time refresh of huge table in replication:
Goto Forum:
  


Current Time: Thu Apr 18 03:21:17 CDT 2024