A Keyword Type Number is a unique identifier for a Keyword Type. The Keyword Block Size option controls the number of Keyword Types Numbers reserved for imported Keyword Types. This can be used with a process that is importing a large quantity of new Keyword Types to increase performance of the import process. By default, when a process creates a new Keyword Type, new Keyword Type Numbers are retrieved from the database one at a time. When the Keyword Block Size option is set to a higher number, the database query retrieves several Keyword Type Numbers at one time. These Keyword Type Numbers are cached in memory in the software, which reduces the number of queries against the database when performing import processing.
The database query always retrieves the number of Keyword Type Numbers specified by the Keyword Block Size option. Set this option to the average size of the batches you are processing. The range of values available is 1 – 1000. If the process only needs one Keyword Type Number but the option is set to 100, 99 Keyword Type Numbers are left unused and cannot be reused.