Configuration: Database

Warning

Do not modify the database settings unless you are an expert and know what you're doing.

Databases.QueryTimeoutInSec

The time in seconds to wait before canceling a query.

  • Type: int
  • Default: 300
  • Scope: Server-wide or per database

This timeout refers to queries and streamed queries.

If a query exceeds the specified time, an OperationCanceledException will be thrown. For the streaming queries the timeout is delayed every time a query result is pushed to the stream. The timeout will be exceeded only if no result is streamed within that time.

Databases.QueryOperationTimeoutInSec

The time in seconds to wait before canceling a query related operation (patch/delete query).

  • Type: int
  • Default: 300
  • Scope: Server-wide or per database

The timeout is delayed every time a query result is processed. The timeout will be exceeded only if no document is processed within that time.

Databases.OperationTimeoutInSec

The time in seconds to wait before canceling specific operations (such as indexing terms).

  • Type: int
  • Default: 300
  • Scope: Server-wide or per database

Databases.CollectionOperationTimeoutInSec

The time in seconds to wait before canceling several collection operations (such as batch delete documents from Studio).

  • Type: int
  • Default: 300
  • Scope: Server-wide or per database

Set timeout for some operations on collections (such as batch delete documents from studio) requiring their own timeout settings.

If an operation exceeds the specified time, an OperationCanceledException will be thrown

Databases.Compression.CompressRevisionsDefault

Whether revision compression should be on by default or not on newly created databases.

  • Type: bool
  • Default: true
  • Scope: Server-wide only

Determines whether revisions should be compressed.
Applies to all databases created on this server.

Databases.ConcurrentLoadTimeoutInSec

The time in seconds to wait for a database to start loading when under load.

  • Type: int
  • Default: 60
  • Scope: Server-wide only

Set how much time has to wait for the database to become available when too much different resources get loaded at the same time

Databases.MaxConcurrentLoads

Specifies the maximum amount of databases that can be loaded simultaneously.

  • Type: int
  • Default: 8
  • Scope: Server-wide only

Databases.MaxIdleTimeInSec

Set time in seconds for max idle time for database.

  • Type: int
  • Default: 900
  • Scope: Server-wide only

After this time, and idle database will be unloaded from memory. Use lower time period if memory resource limited

Databases.FrequencyToCheckForIdleDatabasesInSec

The time in seconds to check for an idle tenant database.

  • Type: int
  • Default: 60
  • Scope: Server-wide only

Databases.PulseReadTransactionLimitInMb

Number of megabytes occupied by encryption buffers (if database is encrypted) or mapped 32 bites buffers (when running on 32 bits) after which a read transaction will be renewed to reduce memory usage during long running operations like backups or streaming.

  • Type: int
  • Default: The default value is determined by the amount of RAM on your machine:
    • 32 bit platforms: 16 MB
    • Less than 4 GB RAM: 32 MB
    • Less than 16 GB RAM: 64 MB
    • Less than 64 GB RAM: 128 MB
    • More than 64 GB RAM: 256 MB
  • Scope: Server-wide or per database