The following table lists common database server features and how they differ between personal database servers and network database servers.
|Feature||Network database server (dbsrv16)||Personal database server (dbeng16)|
|Checkpoints||The CHECKPOINT system privilege is required to use the CHECKPOINT statement.||No system privileges are required to use the CHECKPOINT statement.|
|Communication packet compression||Supported.||Unsupported.|
|Connecting to the utility database||By default, no connections are allowed to the utility database. You must use the -su option to specify the password for connecting to the utility database. See -su database server option.||By default, connections to the utility database are allowed with the user ID DBA and any password.|
|Connection types||Shared memory and TCP/IP by default.||Shared memory by default. To connect with the TCP/IP protocol use the -x option. See -x database server option.|
|Database mirroring||Supported. See Database mirroring.||Unsupported.|
|LDAP as a name server||Can only be used with TCP/IP. See Connections using LDAP as a name server.||Unsupported. Do not confuse this with LDAP user authentication which is supported.|
|Multiprogramming level tuning||Supported. See Database server configuration of the multiprogramming level.||Unsupported.|
|Number of connections||Limited by license. See Editions and licensing.||Maximum of ten simultaneous connections.|
|Number of CPUs||Limited by license.||Maximum of four cores on one CPU.|
|Read-only scale-out||Supported. See SQL Anywhere read-only scale-out.||Unsupported.|
|Windows Mobile||Supported. See SQL Anywhere for Windows Mobile.||Unsupported.|
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|