Re: Conversion from VB4 to VB6 (Speed Problems)

[Quoted] Steve Bosman wrote in message <7r8g5a$e5s$1_at_nnrp1.deja.com>...
>Hi,
>
>I have an application used for downloading data from an oracle database
>using oracle objects for OLE to an access database. I've finally been
>allowed to investigate converting this application from VB4 to VB6 and
>at first everything seemed to be going well, it compiles and runs, but
>despite compiling in VB6 as a standard exe (rather than P-code) the
>application is slightly slower then the VB4 version.

Native code is, in general, approximately as fast Pas -Code.

Exceptions would be applications that do very low-level numeric processing, for example. Since you're using Oracle Objects, this is obviously not a factor.

>Considering the
>major complaint from users is over transfer times this is NOT a good
>thing.

Merely recompiling is unlikely to be of any benefit.

Have you profiled the application to determine where the bottlenecks are? without looking at the application, I would say the single most likely candidate would be in the database access code.

I would recommend using some professional-level performance profiling and debugging aids. NuMega has some VB profiling and debugging tools. I haven't used them, but several people who have think very highly of them.

http://www.numega.com/products/vb.shtml Received on Thu Sep 09 1999 - 19:45:50 CEST