Online Documentation for SQL Manager for InterBase/Firebird

General

The General section of the Database Properties dialog allows you to view/edit the general database properties. The list of available options depends on the server type and version.

 

 

SQL dialect

SQL dialect used. Possible values are: 1, 3.

 

Sweep interval

Number of transactions after executing which automatic garbage collection is carried out.

 

Reclaim interval

The interval in seconds. It determines how often the garbage collector thread will run to release memory from unused procedures, triggers, and internal system queries back to InterBase memory heap.

 

Default charset

Default charset used for the database.

 

Linger interval

Interval in seconds, which allows the server to keep the database open for a period after the last attachment is closed.

 

Difference file

File path and name for DIFFERENCE files (.delta files).

 

Buffers

Pages

Number of database pages per database.

 

Size

Page size (in kilobytes).

 

Cache

Forces writes

Enables/disables the mode of forced writing data on disk.

 

 Group commit

Enables/disables transactions to be committed by a background cache writer thread.

 

 Linger interval

Enables/disables interval in seconds, which allows the server to remain active after all users have disconnected.

 

 Flush interval

Enables/disables database flush.

 

Embedded User Authentication

Use Embedded User Authentication

Specifies whether Embedded User Authentication is used for the database or not.

 

Enabled

Enables/disables Embedded User Authentication.

 

 

Reserve page spaces

Enables space reservation.

 

Read only

Enables/disables read-only mode for the database.

 

---