Differences between the network and personal servers

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.
Network communications	Supported.	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.

Discuter à propos de cette page dans DocCommentXchange.