Re: Long-running queries

In article <3umseo$d28@newsbf02.news.aol.com> mllombard@aol.com (MLLombard) writes: > >The problem is not seen in very many sites. Most users have come to agree >with W. Inmon and others that doing OLTP and DSS against the same database >is not a very workable idea. > >There are obviously a good number of reasons that this is true. Several >vendors have attempted to design databases which will support both type of >workloads, but I do not think anyone has succeeded yet. I disagree. Every major site I have worked with since 1984 needs simultaneous OLTP and DSS. Some sites live with poor interactive performance and many deadlocks. Others minimize this by doing dirty reads and living with inconsistencies and some deadlocks. Others batch up the updates (they really do want OLTP, but can't do it). Replication seems the best solution I have seen. York has implemented several kinds of replication just for this purpose. Cheers, |--------------------------------------------------------------------------| | Michael Leo | The Ingres FAQ is at ftp.adc.com, /pub/ingres. | | York & Associates, Inc.| Also check out /pub/ingres/utilities/NAIUA for | | Minneapolis, MN, USA | the NAIUA Tool Kit. Lastly, access all this via| | (612) 921-8083 (voice) | WWW at http://www.adc.com/ingres/ing-top.html. | | mal@winternet.com | All constructive suggestions/criticism welcome. | |--------------------------------------------------------------------------|