Re: difference between Oracle Provider for OLE DB and OO4O

If you use parameters on your queries and don't keep rebuilding your result sets then you will get very fast results after the first query.(Using parameters and dbRefresh basically is host variables and means the server does a lot less work - no reparsing or redoing the execution plan etc.) I don't believe you will get faster results from stored procedures. Jim
"Jason Gabinet" <jason.gabinet_at_nospam.com> wrote in message news:34pbus0uvv4sh3rld572cadlhk04uuuegt_at_4ax.com...
> We have been developing the application for some time using the Oracle
> Provider for OLE DB v8.1.6.1.0. Right now, we are not using any
> stored procedures, but some of us have heard that using stored
> procedures allows for much faster access, so we are probably going to
> look at them in the future.
>
> I don't belive the Oracle Provider for OLE DB supports server side
> cursors; correct me if I'm wrong. I believe Microsoft, and the MDAC
> has an OLE DB Provider for Oracle, but we didn't mess around with it
> too much. Should we stay away from it, or does it provide the same
> functionality as the Oracle Provider for OLE DB?
>
> I am pretty sure we are using CLOBS, but I have to get with the
> database admins to make sure... they pretty much just gave us the
> table structure and ER diagram, and let us go. Anyway I can find out
> by myself?
>
> Thanks for all your help.
>
> Jason Gabinet
> Geo-Centers, Inc.
>
>
>
>
> On 12 Oct 2000 16:08:29 GMT, timkarnold_at_aol.com (TimKArnold) wrote:
>
> >>My team is currently developing a web application that uses ASP,
> >>Javascript, and VBScript and pulls data from an Oracle database
> >>(Oracle 8i).
> >>
> >>Is there a difference between OO40 and the Oracle Provider for OLE DB?
> >
> >yes
> >
> >>Which one provides more features?
> >
> >I like oo4o, but it depends or your app.
> >Are you using BLOB, CLOBs?
> >Server side v client side cursors?
> >Stored procedures?
> >
> >Or should I just use the Microsoft
> >>OLE DB Provider for Oracle?
> >>
> >>Any opinions?
> >>
> >>Jason Gabinet
> >>Geo-Centers, Inc.
> >>
> >
>
Received on Fri Oct 13 2000 - 03:06:41 CEST