Re: Visual Basic development against Oracle 8.1.7

From: Barbara Kennedy <barbken_at_teleport.com>
Date: Sun, 3 Dec 2000 08:20:22 -0800
Message-ID: <TruW5.1112$Y4.399709_at_nntp1.onemain.com>


Oracle's OLE objects is very fast and the syntax is straight forward. Also if you use parameterized queries correctly you will get great scalability and performance.
Jim
"James Willock" <jwillock_at_btinternet.com.NOSPAM> wrote in message news:90dn5n$pjb$1_at_neptunium.btinternet.com...
> well all i can say is wait for vb7, its gonna be full OO, and in true VB
> fashion kwik to write stuff.
>
> I work with oracle and SQL server all day long, and i'm sorry all you
 oracle
> die hards, but when it comes to business and i've got a deadline to meet
 for
> a customer i can knock something up twice as fast using vb and sql server
> than anything else.
>
> little tip from me...wanna get the money, meet your deadlines.
>
>
> Billy Verreynne <vslabs_at_onwe.co.za> wrote in message
> news:904tc0$p3j$1_at_ctb-nnrp2.saix.net...
> > "J. Pieters" <jeroen.pieters_at_bluewater-group.com> wrote
> >
> > > Does anyone out there has any experience with Visual Basic
 applications
> > > using an Oracle database.

 <snipped>
> > > The advantages and disadvantages.
> > > Performance issues.
> >
> > Maybe VB has improved... but none of client-server development
 experiences
> > (both as a developer and project leader) using VB have not failed to
 kick
 me
> > in the nuts.. hard and repeatedly.
> >
> > Back with VB 4 we ran some sniffer tests. Open database. Select count.
 Close
> > database. VB4 and Delphi 3. Both using the exact same ODBC driver. VB 4
> > generated almost FOUR TIMES!! the network traffic than Delphi 3.
> >
> > With VB 6 and Delphi 4 I did a similar exercise. But it was a bit more
> > complex as VB 6 allowed a plethora of confusing connectivity options..
 ADO,
> > RDO, ODBC, etc. etc. The default results were even more shocking with VB
 6
> > generating a lot of crap (best word to describe) on the network. Again
> > Delphi performed a lot better. I did a lot of tuning to the VB 6 app and
> > finally managed to reduce the crap to almost nothing and got proper and
> > consistent performance from it.. however, Delphi worked that way the
 first
> > time around...
> >
> > Then there are language issues. VB is a very poor OO language. Object
 Pascal
> > used by Delphi gives you the same power and flexibility than C++. And
 the
> > same performance as a C++ executable. I've also used Delphi to write
 backend
> > apps like a TCP transaction server that ran as a NT service. Delphi
 covers
> > the complete development spectrum - from stand-alone apps, client-server
> > apps to server side apps, webbased CGI's and DLL's...
> >
> > Not too mention that the next generation Delphi (called Kylix) will
 enable
> > me to compile my Delphi code on Linux.
> >
> > Guess what development system I'm using exclusively today..?
> >
> > regards,
> > Billy
> >
> >
> >
>
>
Received on Sun Dec 03 2000 - 17:20:22 CET

Original text of this message