Re: Oracle speed problem *****

From: Christian Kaas <c.kaas_at_odn.de>
Date: 1997/09/01
Message-ID: <340bdd8b.22063225@news.nuernberg.odn.de>#1/1

>I am discouraged with ORacle and ODBC.

                                  ^^^^

you're right ! But to be honest the problem is no ODBC nor is it Oracle ! the problem is the way ms-access uses ODBC - through JET ! the jet engine slows down access to oracle by at least 150% ! try using pass through queries (which of course are not updatable in access) and see them fly - OR - use another product like i did - i switched to borlands delphi !

Yours

On 29 Aug 1997 11:12:00 GMT, "Carlos García" <cgg_at_encomix.es> wrote:

>Can anyone help me?
>
>This questions are about Oracle and ODBC over Windows NT.
>
>We are trying to make an app using Visual Basic 5.0, RDO 2.0, ODBC driver
>from Microsoft,
>in the client-side, and Windows NT server 4.0 and Oracle 7.3.2.2.1 in the
>server-side.
>
>1.- What is the minimal requeriments for install a good Oracle Server using
>Windows NT?
>We are using in one case a Pentium Pro 200 with 64 Gb of RAM and in other
>case a HP
>Netserver E40 Pentium PRO 200 with 64 Mb or RAM with, in the two cases, 4
>MB one hard disk.
>
>2.- We make tests using a Access database and a ODBC connection. The tests
>are made in the
>same machine, in other words, Oracle is running over the same machine that
>run the test
>program. The ODBC-Sql*Net connection make a loopback connection.
>Our test consist in making a select * from a table within 7800 rows and
>fill-in a listbox with
>one of his columns. We have the same table and data in the ORacle database
>and in a Access DB.
>Well, when we make the query, Access retrieve the data and fill the list in
>4 seconds, 0 seconds
>are taken for make the query and 4 seconds are taken for retrieve the 7800
>rows and fill the
>list box.
>Using all combinations of cursors, etc... accessing the Oracle Db using
>ODBC and filling the listbox
>take 14 secs, 0 seconds are taken for make the query but 14 seconds are
>taken for retrieve data and
>fill the listbox.
>In the two cases, the test code make a movenext for move around the table.
>Why this differences?
>
>3.- For the same case, if we use the Oracle Objects for OLE, making the
>query are fast too, but
>when we try to make the movenext for all the rows, the time used is 40 secs
>!!
>
>Please, can anyone help me with this?
>I am discouraged with ORacle and ODBC.
>
>Please e-mail me at cgg_at_lcg.servicom.es
>
>Thanks very very much.
>
>
>

Christian Kaas
Client/Server development and consulting Fax. 49-9129-5518
Phone 49-9129-5508 Received on Mon Sep 01 1997 - 00:00:00 CDT