Sybase Wan Performance
I am currently running Sybase Anywhere 10 and connection to the database on the LAN side works great, but on the WAN side it runs really slow.
I was wondering if Sybase 16 will improve my overall performance?
Jeff Albion replied
I think you may need to consider a different approach to diagnosing your performance issue: while we certainly encourage all customers to move to SQL Anywhere 16 (as SQL Anywhere 11 is no longer supported by engineering and will not be putting out further fixes), depending on what the actual problem is, simply looking at upgrading the version may not address the root cause of your problem and may not give you any clues as to what to further look at.
That being said, there are also bugs and other things that affect both how the client and server interact, and even the performance of the database server itself - moving to SQL Anywhere 16 with the latest Support Pack will definitely give you the best opportunity to avoid all of these known issues that have been improved since version 11 was released. Even if you aren't moving to SQL Anywhere 16, upgrading SQL Anywhere 11 with the latest SP version is recommended.
- Which version of SQL Anywhere 11 are you currently running on your clients and server?
- Which API are you using to access the database?
- Have you tried using the built-in Diagnostic Tracing in SQL Anywhere 11 to determine the performance differences for these two use-cases?
- Do you have a support plan with us?
Opening an incident with SAP technical support is usually the best way we can directly interact with you to collect information diagnostics and help guide you to test the two scenarios. If you're going to continue working on your own on this problem, creating a performance test with the fetchtst tool can also help determine where the performance time for particular queries is really going.
SAP Active Global Support