Slow Data Connections

mjgazzo
mjgazzo Member Posts: 3
edited 2004-05-01 in Navision Attain
I just started working with a client that is trying to import a large amount of Navision data to a sql server database from a remote location. The source is the MS business solutions for Navision database - not SQL Server.

The data transfer is extremely slow. The communication line is a T1 and pings very fast. I suspect that the DSN/driver is not configured correctly. When I tried to evaluate details of the DSN, DTS connections etc, it took over 5 minutes to connect on every ocassion. A simple table of 300 records required 12 minutes to transfer. Some information from the DSN configuration is as follows:

CODBC driver version 3.01.02.8097
net type is tcp
options: commit cache, enable blob and read/write are all checked.
option field is text.

Any insights as to what is causing the slow performance would be greatly appreciated.

Thank you

Mardy

Comments

  • Nats
    Nats Member Posts: 12
    Mardy,

    For a similar situation in my company. I found the solution was the Roles given to the user id used in the ODBC connection. Once I gave full SUPER access, it worked out fine.

    Hope this works for you.
    Nats
    ...
    ...
    Love, Light & Peace
  • mjgazzo
    mjgazzo Member Posts: 3
    Nats

    Thanks for the insight. I checked and the user ID has super access.

    I ran some tests and found that on average it takes 3 minutes to import 1000 records into a sql server 2000 database. That's terrible. We're looking at options.

    Thanks

Categories