Re: VB and Oracle

From: scott yu <cyan_at_physics.phy.uab.edu>
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

  1. VB(jet engine) -ODBC -SQLNET - ORACLE SERVER
  2. VB(ODBC API) -ODBC - SQLNET -ORACLE SERVER
  3. 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 one
and 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

Original text of this message