Re: Access 2.0 as front-end
From: Peter Herdman-Grant <100435.153_at_CompuServe.COM>
Date: 5 Oct 1994 22:52:00 GMT
Message-ID: <36vamg$r0i$1_at_mhadg.production.compuserve.com>
Peter Herdman-Grant, CACI Limited ODBC APPS ARE OUR BUSINESS! Received on Wed Oct 05 1994 - 23:52:00 CET
Date: 5 Oct 1994 22:52:00 GMT
Message-ID: <36vamg$r0i$1_at_mhadg.production.compuserve.com>
What you are intimating is the key consideration when developing ODBC/Access applications. In the absence of stored procedures to achieve host side filtering, Access will do its best to pull the minimum host data to the PC to achieve a heterogeneous join. There are many ways to overcome this and achieve great Apps, design your database to limit heterogeneous queries. If the major queries in your App involve heterogeneous joins, you've designed the data model wrong! Understanding that data resides in different places, be sure to re-locate the data before trying to run a performant application against it.
Is Oracle any better than Ingres?
Regards,
Peter.
Peter Herdman-Grant, CACI Limited ODBC APPS ARE OUR BUSINESS! Received on Wed Oct 05 1994 - 23:52:00 CET