cancel
Showing results for 
Search instead for 
Did you mean: 

Wan ODBC slow SQL ANYWHERE 16

user27460
Discoverer
0 Kudos

Hello,

using ODBC with WAN is very slow, not with LAN.

We don't have any restriction on our network, what parameter car be modified ?

We are using sap sql anywhere 16

chris_keating
Advisor
Advisor
0 Kudos

There are a number of tweaks, depending on the specifics of the issue, that can be considered.

You may want to connect with connection parm LOG=<file> and look at the resulting <file> on a slow WAN case. It may make recommendations related to PROWS and PBUFF connection parameters.

See Review Tips for improving performance in the documentation.

Options to investigate (some discussed in the Tips)

  • CommBufferSize (CBSIZE) connection parameter / -p server option
  • Compress (COMP) connection parameter / -pc database server option
  • PrefetchBuffer (PBUF) connection parameter
  • PrefetchOnOpen connection parameter
  • PrefetchRows (PROWS) connection parameter

Accepted Solutions (0)

Answers (2)

Answers (2)

user27460
Discoverer
0 Kudos

Hello, there is no more support for sql anywhere 16

chris_keating
Advisor
Advisor
0 Kudos

SQL Anywhere 16 has been End of Mainstream Maintenance (EOMM) since Dec 31, 2018. Support is still available, as far as I know, on a best effort basis - any defects will only be addressed in actively supported versions. That is why I suggested you raise his question with support. They are better equipped to do the triage likely needed for this question than can be offered in an user community.

user27460
Discoverer
0 Kudos

Hello, thank you for the response, i tried to change every parameters you recall but no success.

chris_keating
Advisor
Advisor

If these are not helping, it likely that this issue will be too involved for a forum. If you have support, I would recommend pursuing a support incident.