Re: [Q] Connecting to Oracle over Internet

Andy,

I have had experiences similar to Jerry's such as:

    Access -> ODBC -> SQL*Net (Firewall/T1) via Internet (Cable Modem) SQL*Net -> Oracle8

    and
    IE 4 (Firewall/T1) via Internet
    (T1) IIS 4 -> Business Objects (CORBA) -> SQL*Net -> Oracle8

both could/would give good performance unless the Internet was slow. In this scenario only the speed of the network was a factor, not ODBC or even CORBA!

Mike Rose

mmrose_at_home.com

<zaq42_at_yahoo.com> wrote in message news:7gplua$ji8$1_at_nnrp1.dejanews.com...
> I've been tasked with connecting our web query system (uses Cold Fusion)
to
> an Oracle database, via the internet, that is ~18 hops away (another
> company). The connection is quite slow.
>
> I can use SQL Plus and select table at a reasonable speed, considering the
> architecture.
>
> In order to connect to the Oracle Db via our web application, I must use
ODBC.
> Using the web architecture, ODBC, and the 18 hops really break down when I
> attempt to return 8 10-column records from a two table join (640,000 x
3000
> records).
>
> I'm able to return 50 1-column records from a query against a 3000 record
> table.
>
> Has anyone succuessful used ODBC & Oracle over the net? Does anyone think
> this is a viable option for us...or do I just need to give up this ODBC
crap
> (please say give it up).
>
> Thanks in Advance!
>
> Andy Carter
>
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Wed May 05 1999 - 12:50:22 CDT