Re: Best Windows-based database for replication/synchronization

"tbone" <noneedto_at_email.me> wrote in message news:72srp1t5gc598khsthnecci3gic6srsq7n_at_4ax.com...
> 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.

Ingres r3 is free and includes a replicator. Look at www.ingres.com.

> 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 think you are right. Network I/O is very slow and erratic. Networks are good at moving huge chunks fast, but they are not real prompt about moving any given chunk. Except on a dedicated cable expect wildy variable response times. Add interprocess communication delays and context-switching delays on top of that. Once the average service delay exceeds the average interval between requests response time goes approximately infinite, with little or no warning.

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

Maybe.

Roy Received on Tue Dec 13 2005 - 10:08:13 CET