Re: Distributed Join

In article <1995Jun7.130349.10170@eisner> armstrong@eisner.decus.org (Borden Armstrong, United Airlines) writes: >From: armstrong@eisner.decus.org (Borden Armstrong, United Airlines) >Subject: Re: Distributed Join >Date: 7 Jun 95 13:03:49 -0400 >In article <james.lawrence.45.0012036C@EPAMAIL.EPA.GOV>, james.lawrence@EPAMAIL.EPA.GOV writes: >> 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. >Not entirely true. Examine Digital's DBIntegrator. And since DBI can >front-end both Sybase & Oracle7 (as well as DB2, Oracle Rdb and a number of >other databases) it is possible to perform optimised distributed joins across >database platforms, not just across databases. >Disclaimer: I do not work for Digital, but I did beta-test the product. >Borden Armstrong United Airlines - SFOKI >Sr. Staff Analyst - Database Design San Francisco International Airport >Armstrong@Eisner.Decus.Org San Francisco, CA 94128 >[Disclaimer: All opinions herein are my own and not those of my employer. All >advice herein is worth exactly what you paid for it.] Borden: We have just finished evaluating DB Integrator against an RDB 6.1 database and were very disappointed in the performance of this tool. As an example the program before dbi took about 10 seconds to load some initial information and display the opening menu. The only changes made were to create a DBI database that pointed to the original database. All data resided in the same database as before but the program pointed to the dbi database and the same test takes over 2 minutes and 30 seconds. All other tests show about a 35% increase in elapsed time to perform tests. Do you have any ideas on what we might do to improve on this quite dismal performance problem. Thanks, John Hough