|
Over time, the functionality of dbeng and dbsrv has been drifting apart. In Version 12, for example, the new dynamic multiprogramming level (-gn) tuning feature is disabled in the personal server. That difference is NOT listed in the "Server differences" Help topic http://dcx.sybase.com/index.html#1200en/dbadmin/da-running.html Are there any others? This is an important question since a SQL Anywhere engine can be run in standalone mode (one or zero actual client connections) but can still have extreme performance requirements; e.g., many simultaneous internal connections from events and services, many batch-style queries, and so on. The choice between dbeng and dbsrv is NOT necessarily a choice between "personal" and "network"... not any longer, not with the feature drift. ...or is the answer, "Always run dbsrv unless you have a good reason to run dbeng"? Here's another difference, not performance-related: The default permissions required to stop the server using dbstop are different: dbeng -gk all versus dbsrv -gk DBA. |
|
This is not (yet) an exhaustive list - I will add to it when needed. Personal server
Network server
Please provide this great piece of information to the DCX team... 4
I actually got it from the DCX team. They began putting this list together just a week or two ago. @Graeme: Nice that you keep the list current! |
Added a "documentation" tag - hopes it makes sense for answers that help to complete the official docs.
I'm gonna leave tagging to other people... I keep coming up blank :)