IMetabase.UseReservedKeys

Syntax

UseReservedKeys: Integer;

Description

The UseReservedKeys property determines the number of keys which will be reserved for using 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.

Setting the UseReservedKeys property enables to reserve the specified number of keys with the first query. Reserving requires the 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 are used, the reserving procedure is executed anew.

By default the property is assigned the "0" value, and the keys are not reserved.

NOTE. Keys reserving was implemented only for servers on the MSSQL base.