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 |
|
itm
Starting Member
1 Post |
 Posted - 2007-11-14 : 12:30:00
|
| We have a SQL Server 2005 database supporting our main ecommerce site. It is hosted remotely by our ISP. We currently maintain a local copy of this database by running daily stored procedures to keep the local copy up to date. However we'd like to explore the use of replication over HTTPS as an alternative means of keeping the local copy in sync with the ISP database.Could anyone comment on the technical feasibility of doing this, given that transaction throughput on the ISP server can be several hundred hits per hour? Is web-based synchronisation likely to suffer from poor performance, or to adversely affect users of our ecommerce site? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-14 : 23:28:01
|
| What's link speed? May have big latency over slow network, but shouldn't affect users. |
 |
|
|
dirtydavey
Yak Posting Veteran
80 Posts |
Posted - 2007-11-15 : 05:14:42
|
| What connection spead is the ISP running at?Also whats the upload spead.I have had replication running from new york to london many times, and its worked fine.As rmiao said, you may see some latency issues but it will work. |
|
|
|
|
|
|
Performance of web synchronisation?