Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
noamg
Posting Yak Master
215 Posts |
 Posted - 2003-12-14 : 05:29:31
|
| hi,I have to synchronization one DB with 2 others in real time.is the replication mechanizen working fast ?or how long time it takes in case of insert a new row into DB1 untill it inserts it into the other 2 db ?thanksNoam Graizer |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-12-15 : 12:46:55
|
| It depends on how you configure it. If you choose to use continuous replication, then it should go pretty fast. You can change the profile so that it polling interval is faster than the default. You could also choose to use a two-phase commit so that they both happen at the same time. This will make the data changes slower on the source database though.Tara |
 |
|
|
|
|
|
replication performance