Re: VB5 --> ODBC --> Oracle 7.3 Slooowww.....

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: Tue, 28 Apr 1998 14:22:18 +0200
Message-ID: <6i4hh8$gvn$1@hermes.is.co.za>

Jason Salter wrote in message <3540e834.3866309_at_news.demon.co.uk>...
>We've got a few VB apps (versions 3 and 5) running on Windows 95 and
>NT which are using Oracle's ODBC (version 2.5.3.1) to talk to an
>Oracle 7.3.4 database running on NT.
>
>The problem is that the application runs very slowly.
<snipped>

What network protocol are you using? A real wild shot, but if you're not using sockets but pipes across TCP/IP then it is one way to speed up the connection. With SQL-Server and ODBC clients, you can cut down the network traffic a lot by changing from pipes (used to be the SQL-Server default) to sockets.

But you're probably are using all the right stuff, with the exception of ODBC of course... :-)

AFAIK is there very little you really can do to speed up the applications, without going thru every single line of VB code that accesses the database and optimise it. And data bound controls are a no-no. A better solution will be to use a development tool that supports native SQL*Net such as Delphi or Powerbuilder (which is probably not what you want to hear... ;-) ).

regards,
Billy Received on Tue Apr 28 1998 - 07:22:18 CDT