IMetabase.ReserveKeys

Syntax

ReserveKeys(Count: Integer);

Parameters

Count. The number of key that need reserving.

Description

The ReserveKeys method reserves the specified number of keys for usage in the analytical platform.

Comments

When the GenerateKey method is being executed, a query to the system sequence for generating a new key is formed. The GenerateKey method is also used in the kernel of the platform on creating new objects.

If a big number of keys is required to be generated, this method can be used to reduce the number of queries to the DBMS server. Calling the ReserveKeys method leads to execution of the procedure on the server that returns the specified number of keys. Obtained keys as required will be used in the kernel of the platform without creating additional queries to the DBMS server.

After the reserved keys have been used, the kernel generates new queries to the system sequence as required.

NOTE. Keys reserving was implemented only for servers on the Microsoft SQL Server base.