| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: MS Access as a front-end to Oracle DB
Dick,
what if the second table is not local, but another remote ORacle table. How would the things change in this case?
Gene
--- "Goulet, Dick" <[EMAIL PROTECTED]> wrote:
> Yes, you are misunderstanding it. A simple
> statement like your will result in only the data
> required being sent over the network. But if you
> add in a second table things change, especially if
> that table is a local access table.
>
> Dick Goulet
> Senior Oracle DBA
> Oracle Certified 8i DBA
>
> -----Original Message-----
> Sent: Friday, June 20, 2003 5:45 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi all:
>
> I have been hearing from many people that MS Access
> is
> bad as a front-end tool because it tends to do data
> processing on the clien side instead of the DB side
> thus moving way too much data over the network.
> Assuming that this is correct, what is the mechanism
> of this? If I execute a simple query like:
>
> select f1, f2 from t1
> where f3='X';
>
> is MS access going to copy the whole table t1 to my
> machine and only show the rows with f3 equal to 'X'?
> Am I misinderstanding it?
>
> tia
>
> Gene
>
> __________________________________
> Do you Yahoo!?
> SBC Yahoo! DSL - Now only $29.95 per month!
> http://sbc.yahoo.com
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> --
> Author: Gurelei
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- 858-538-5051
> http://www.fatcity.com
> San Diego, California -- Mailing list and web
> hosting services
>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Mon Jun 23 2003 - 08:36:06 CDT
 |
 |