TurboDB VCL Component Library

TTdbDatabase.IndexPageSize

TTdbDatabase        See also

Previous  Top  Next

Specifies the page size of the next index to be created.

Delphi syntax:

property IndexPageSize: Integer;

C++ syntax:

__property int IndexPageSize = {read=FIndexPageSize, write=FIndexPageSize, nodefault};

Description

Usually TurboDB calculates the size of its index pages internally. Using this property you may optimize the index in special cases. The property specifies the size of a B-tree page in bytes. This size will be used for all subsequent index creations using TTdbTable.AddIndex.

The smaller the index pages are, the higher the index B-tree will become. Normally, you should choose the size of the index page such that between 10 and 300 table rows can be indexed per page. If in doubt, experiment with different sizes and find out, which one is the fastest.