Re: HELP! Low speed with ODBC

From: ECT Consultant <consult_at_anl.gov>
Date: 1997/09/02
Message-ID: <340C859D.4A590B29@anl.gov>#1/1

We use MS Access 8.0 with Oracle ODBC version 2.0.0.3.1.1 but we have good response time. We have tables with many more rows than yours. Maybe you should take a look at your network by using traceroute or tracert at win95 to solve the bottleneck if any. Then check your database to see if you are using an index. If your table is not big (500 rows only), disable the index to reduce extra io will speed up your speed. On your client side, change your odbc setting with arraysize will also help.

Victor Tsien

Lars Line Vaaland wrote:

> I am using MS Access 8.0 with Oracle ODBC version 2.0.0.3.1.1, but the
>
> response time is extremely slow. Several minutes to pick up a table
> with
> less than 20 fields and 500 records. I have tried to switch on SQL
> pass-through in MS Access, but with no improvement. Anyone got any
> idea
> on how to improve the response time.
> Thanks in advance.
> larslv_at_online.no
> --
> Lars Line Vaaland, Hildertunet 6, 1312 Slependen, Norway
> Tel.: (P): +47 67 56 91 69
> Tel.: (W): +47 67 10 93 43
> PS: 965 32 713
> E-mail (W): lars.vaaland_at_umoe.no
Received on Tue Sep 02 1997 - 00:00:00 CDT