May 8, 2003 at 9:49 am
I am considering using transactional replication for our great plains system because our production systems use these tables as lookups. I want to decouple them, but will massive updates to the publisher (accounting) result in massive updates to the subscriber table (production), resulting in blocking..., hence not achieving my goal? Thanks... Matt
May 8, 2003 at 11:16 am
To some degree it will, depends on how you replicate the transactions. If you replicate the stored proc call, one big transaction is one big transaction. If you're replicating the data changes, SQL limits how much goes over per batch.
Andy
May 8, 2003 at 2:28 pm
Also to run updates faster and with better performance, if you are running SQL with SP3, you should consider using the sp_scriptdynamicupdproc, to create and use the replication sps at the subscriber.
This will only updates the rows that need to be changed.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply