on 2013 Nov 13 3:24 PM
We have a commercial application that was running pretty well in SQL Anywhere 8.03. We have been upgrading our customers to 11.01 and have found that several queries are running far slower on the new engine. I post a execution plan and databases option if we should be making some kind of change to the way we structure our queries that would allow us to recover at least the level of performance we enjoyed with 9.02. tha laura
ps I can not attach files!!!
Request clarification before answering.
Hi Laura, When you moved the database from 9.x to 11.x did you migrate the database, or did you create a new 11.x database and reload everything into it ? Many of the 11 features will not take effect until you create an 11.x database.
-Rex-
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Upgrading to SA11 requires rebuilding the database, it won't run SA9 DB directly
User | Count |
---|---|
52 | |
10 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.