When we look at the SQL Anywhere product line we see the Work Group Edition, and the Standard Edition (Chip License) and the On Demand Edition.

Despite the various licensing constraints, if we were to compare the function and performance of these versions on a single Dual Chip Environment with 6 cores per chip - would they all perform similarly or are there advantages or limitations built in which would make one out perform the other?

asked 29 Jul '13, 01:16

Glenn%20Barber's gravatar image

Glenn Barber
1.1k234051
accept rate: 0%

edited 29 Jul '13, 01:17


Thank you for a "can of worms" question... :)

If you are asking about SQL Anywhere size and number limitations, then no, there's no difference, the editions are all the same; let's assume you are not asking about UltraLite and UltraLite Java edition database limitations.

If you are asking about Marketecture limitations, then yes, there are some; see the Editions and licensing, SQL Anywhere database servers and Server Licensing utility (dblic) Help topics, as well as the Editions and licensing web page (which may be the most useful link).

I'm guessing here, but if your question can be restated as

"Are there any differences in performance between Workgroup, Standard and Advanced edition copies of dbsrv16, running without either of the High Availability or In-Memory features, on a two-socket computer?"

then the answer is "no".

I think :)

alt text

PS if you use the Foxhound database monitor then there might be a reason to use the Standard edition of SQL Anywhere instead of beating a Workgroup licence to death :)

permanent link

answered 29 Jul '13, 08:51

Breck%20Carter's gravatar image

Breck Carter
26.3k430601866
accept rate: 21%

edited 29 Jul '13, 08:52

All editions have the same limits, so they don't have performance differences. The only exception might be the on-demand edition, I'm not sure what's in there.

permanent link

answered 29 Jul '13, 07:40

ASchild's gravatar image

ASchild
777222740
accept rate: 14%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×242

question asked: 29 Jul '13, 01:16

question was seen: 578 times

last updated: 29 Jul '13, 08:52