Re: Distributed Join

In article <james.lawrence.45.0012036C@EPAMAIL.EPA.GOV> james.lawrence@EPAMAIL.EPA.GOV writes: >Both oracle and ingres have done a much better job of making it possible to >have multi-database joins that are transparent. Oracle has been doing >it for about as long as ingres. However anyone considering this for >production systems should be aware that nobody is optimizing distributed joins >yet. Unfortunately this means that there is no value in making it transparent >, since it wouldn't perform worth a shit. How much is that worth, exactly ;-} Seriously, not everybody needs complete network optimization. Lots of people use local databases with poor optimizers and are very happy with them. So the "no value" statement is false, IMHO. James should have stated: "... where high performance is required, it wouldn't perform worth a shit." 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) 831-0077 (voice) | WWW at http://www.adc.com/ingres/ing-top.html. | | mal@winternet.com | All constructive suggestions/criticism welcome. | |--------------------------------------------------------------------------|