Re: Oracle Objects for OLE vs. RDO?

Gordon Cartwright wrote:
>
> This statement conflicts with my very limited experience. We too are trying to
> decide on the method to access Oracle from VB4. I have found RDO and OO4O to
> provide similar access times to get the data from the server to the client (Win
> 95), but OO4O is v.slow at referencing individual columns once they are there.
>
> As an example, 1000 rows can be retrieved and loaded into a list box via RDO is
> 2 secs. Via OO4O it takes 18 secs.

Yes, it's slow at that. There are usually alternatives to this, such as binding
a more advanced multi-column combo box (drop-down list) to a data control. Then it
loads only what the user scrolls to. Also, you could try a filter such as display
Counties only in NY state, instead of all counties in the USA.

People frequently misuse OO4O to access fields in a recordset row by row when they
could compose a SQL UPDATE query to do the same thing in 1 swipe!

>
> Re RDO, be v. wary of it's bound controls. For every RDC on a form you get a
> separate Oracle session. Yuk.
>
> I haven't managed to try OO4O with bound controls yet, because that bit isn't
> shipping. Oracle told me it should be available early in the new year.

I have used OO4O v1 w/VB 3.0 pro and once the query is done to retrieve rows,
advancing next, previous, first, last is very fast. I assume the same performance
is to be expected w/VB 4 and OO4O v2. Tweaking the query is possible via properties
such as READ_ONLY, NO_CACHE, etc. All bound controls that are bound to the same data
control use the same Oracle session.

HTH, Steve Chapman Received on Thu Jan 02 1997 - 00:00:00 CET