Page 1 of 1

Table replication...

Posted: Wed Feb 12, 2014 10:58 am
by tboyer
I was wondering if you have any "best practices" advice for table replication. We want to mirror one of our main production tables so we don't have table contention between background processes and user interactions.

The tables are in the same database, so we're planning to write a vortex script to cron every 10-15 seconds and query for inserts/updates in the source table. If the previous instance is still running, the script will just stop. Any pitfalls to this that you see?

Thanks,

Tom

Table replication...

Posted: Wed Feb 12, 2014 11:47 am
by markawillson
The separate process you propose is probably the best way to keep the mirroring isolated from the user. Things like triggers or manually updating both tables at the same time would tie mirroring to the user activity.

Make sure you have the index needed to make your check for recent activity fast.