Wan ODBC slow SQL ANYWHERE 16

[user27460]

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]

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

[user27460]

Hello, there is no more support for sql anywhere 16

[chris_keating]

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.