Re: VB and Oracle
Date: 1997/09/09
Message-ID: <3414E5CF.5CA4_at_physics.phy.uab.edu>#1/1
Dr. Memory wrote:
>
> A mist arosy from the scrying-bowl, and "Alan Yost"
> <alan.yost_at_Alphawest.com.au> was heard to utter:
>
> >Are there other developers out there who are successfully creating large
> >scaled client/server applications using VB and Oracle that are happy with
> >these two tools and if so what the hell are you guys doing right????
>
> We're getting decent performance using Oracle Objects for OLE, but due
> to network overhead we wound up writing a database layer that does
> caching using a local Access database.
I develop client/server using the following mothod
- VB(jet engine) -ODBC -SQLNET - ORACLE SERVER
- VB(ODBC API) -ODBC - SQLNET -ORACLE SERVER
- VB - ORACLE OBJJECT -SQLNET(CLI) - ORACLE
the method two is fastest, method one is simplest. the mothod three is stablest. After fine turning database(prime keying and normalize), the method oneand three perform very close.
so, I will suggest fine turing and using method three
scott yu programmer/Analyst Pemco Aeroplex Inc Received on Tue Sep 09 1997 - 00:00:00 CEST