Re: VB -> ORACLE on UNIX

In article <pgk-0909940921580001_at_paulkampmac.pacersoft.com> pgk_at_pacersoft.com (Paul Kamp) writes:
>From: pgk_at_pacersoft.com (Paul Kamp)
>Subject: Re: VB -> ORACLE on UNIX
>Date: Fri, 09 Sep 1994 09:21:58 -0500
 

>In article <34ped2$7t4_at_africa.lm.com>, rcoates_at_telerama.lm.com wrote:
 

>> We chose Glue over ODBC and some other tools we tried because of
>> Glue's speed and because, as far as our vision now goes, we do not see
>> ourselves using any other databases than Oracle.
 

>Just curious, how did you measure performance/speed? We are always trying
>to improve performance in our product set and are trying to define
>appropriate metrics for performance of network db access.
 

>Thanks in advance for the help.
 

>--
>Paul Kamp
>Pacer Software, Inc.
>pgk_at_pacersoft.com
>Applelink: PACER

I did a small benchmark using Powerbuilder comparing retrieval between Oracle's native API and Oracle's version 7 ODBC driver. The ODBC driver was actually slightly faster on small return sets. Larger return sets could be done with arrays in the native API and this gives it an advantage over the ODBC driver.

VB user's should beware, it looks like MS makes some assumptions about ODBC drivers and Oracle's doesn't work well with VB, flaky behavior, works great with everyone else's products. MS says no plans for them to produce an Oracle version 7 ODBC driver. We had to use Oracle glue to get VB/Oracle to work well. Have also had good experience with Q&E stuff but they have a per seat runtime since changing ownership.

Lawrence James
Martin Marietta
James-Lawrence_at_epamail.epa.gov Received on Tue Sep 20 1994 - 02:59:56 CEST