Mimer SQL on Windows
Mimer SQL on Windows > Mimer Administrator > Local Databases > Local Database Memory Parameters
Local Database Memory Parameters

The parameters that control memory consumption by the database server are divided into two areas, the bufferpool and the SQLPool. The bufferpool contains pages that hold actual database data and various control information about databanks, tables, and transactions in the system.

The SQLPool contains information about users logged into the database system, compiled SQL statements and procedures, and so on. The SQLPool will automatically allocate additional space if needed. The upper limit for this, is the amount of paging file allocated on the machine or the amount of memory a single process may allocate. It is possible to restrict the amount of memory consumed by the database server by specifying a maximum size for these areas.

See Also