Re: creation of ODBC linked tables to Oracle very slow in Access

From: Sybrand Bakker <oradba_at_sybrandb.demon.nl>
Date: Thu, 22 Nov 2001 19:14:51 +0100
Message-ID: <k1gqvtogtjl1bq7edq4v0v6ti4m0mgpi5k@4ax.com>

On 22 Nov 2001 02:15:01 -0800, wdu_at_cyberlan.nl (Wouter van Duijvenbode) wrote:

>Hi,
>
>I use an access database to link to an ODBC Oracle database. Whenever
>creating a linked table the process lasts endlessly! For example, creating
>260 linked tables lasts for about 3 hours!
>
>Ik checked the server preformance monitor (NT4SP6) to check for possible
>bottlenecks. However, I found none. Network is 10Mbit switched, so that
>seems to be sufficient in terms of capacity. Searching access help files has
>not solved this problem.
>
>Has anybody encountered this strange problem, or does anyobody has an idea?
>
>Thanks in advance,
>Wouter, the Netherlands.

10 Mbit, rofl!! In a previous job we dropped that replacing it by 100Mbit in *1995*

ODBC will, by virtue of it's architecture, *never* be fast.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Nov 22 2001 - 12:14:51 CST