I have found that the Oracle's OLE Objects is fairly essay to use and if you
read the documentation on performance you can get a lot better performance
than if you use ODBC. The caveat here is that you can still write the
application so it will not perform well under either scenario (ODBC or OLE),
but if you make good use of parameterized queries and do not keep reparsing
them you can cut down on CPU usage (sql area reloads and reparses)
dramatically. Result is faster and more scalable.
Jim Kennedy
lk wrote in message <36b3d886$0$16682_at_nntp1.ba.best.com>...
>Can anyone point out the differences between using odbc vs ole for
cnnecting
>from visual basic to Oracle database.
>
>Thanks.
>
>Larry Kaufman
>President
>CSS
>kaufman_at_csscomp.com
>
>
Received on Sun Jan 31 1999 - 10:31:27 CST
