Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!hammer.uoregon.edu!canoe.uoregon.edu!newshub.sdsu.edu!pln-e!spln!dex!extra.newsguy.com!newsp.newsguy.com!news2
From: tbone <noneedto@email.me>
Newsgroups: comp.databases.theory
Subject: Best Windows-based database for replication/synchronization
Date: Mon, 12 Dec 2005 17:02:32 -0500
Organization: http://newsguy.com
Lines: 16
Message-ID: <72srp1t5gc598khsthnecci3gic6srsq7n@4ax.com>
NNTP-Posting-Host: p-572.newsdawg.com
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Newsreader: Forte Agent 3.1/32.783
Xref: dp-news.maxwell.syr.edu comp.databases.theory:35086

Are there Windows databases on the market that allow a database to be
maintained simultaneously in two locations? IOW, both copies of the
database are automatically and continually kept synchronized with each
other to within a few seconds.

A customer has asked me to upgrade a system I did for them many years
ago, based on Microsoft Access, in order to improve the response time
when the loading is heavy. Presently, the web server and the database
server are on two different machines and I think the communication
between the two is the bottleneck when traffic is heavy.

I'm wondering if a synchronizing database would be an effective
solution without having to rewrite a lot of ASP code.

Thanks
tbone