Server Type
This sets the type of the database server process. Different functionality will be available in the database server depending on this choice. The actual choices available depends on which edition of Mimer SQL is installed on the machine.
The server type may be one of:
Server type | Description | ||
---|---|---|---|
Experience | Advanced set of database server functionality in a multithreaded server. Both data manipulation (DML) and Data Definition Language (DDL) supported. In version 10.1 this server type does not support user defined types. Otherwise, it supports a more sophisticated version of SQL than an Engine server. This is detailed in the release notes. | ||
Engine |
Advanced set of database server functionality in a multithreaded server. This type of server supports user defined types and both DML and DDL. This type provides backward compatibility with earlier versions of the Mimer SQL database server.
| ||
Mobile Experience | This is a small footprint multithreaded server that supports precompiled SQL statements and data manipulation statements. Data Definition statements are not available. | ||
Mobile | this is a small footprint multithreaded server that supports precompiled SQL statements only. | ||
Micro | This server type has a very small footprint. It only uses precompiled SQL statements in a single threaded server. This type of server is used when memory is a very limited resource. | ||
Auto | This is an in-memory server type with a very small footprint. It only uses precompiled SQL statements in a multi threaded server. The schema is decided by running the schema compiler on an Experience database server and creating a dynamic link library that holds the schema and statements in the Mimer SQL Auto server. The Mimer SQL Auto server also has realtime support. |
See Also