Re: OO4O and ODBC performance issue

On 25 Feb 1998 12:30:48 -0500, kapdo_at_Glue.umd.edu (Kap Do Jang) wrote:

>
>Hello, everybody..
>I'm comparing the performance between OO4O and ODBC to retrieve data from
>oracle 7.3. First time, I expected that OO4O should be better than ODBC,
>but surprisingly ODBC is about 4 times faster than OO4O.
>My test program is just retrieve couple of thousands records and display
>them in a table. And the problem with OO4O is that retrieving value from
>dynaset field consumes most of time.
>If I use OFieldCollection rather than OField to retrieve from dynaset, it
>improves a little, but still much slower than using ODBC.
>Is this usual or did I do something wrong?
>Any comment about this matter would be appreciated.

I've worked with Oracle Objects for OLEand VB and found that it is very important to extract the field object as a separate reference.

I forget the syntax but conceptually, I had a choice of something like:

   value = dynaset.field[name].value

after every fetch or someting like  

   set Fld = dynaset.field

   value = Fld.value

after every fetch.

The latter would run at least 10x faster, if not more. Received on Sun Mar 01 1998 - 00:00:00 CST