Block Fetching

A dynamic configuration setting called “block factor” can be used to tune performance. This factor is the number of records retrieved by Zim each time it fetches records from the database. The larger the number, the fewer times Zim has to query the database, and the more time it takes to retrieve a block. So, the number must be adjusted to an appropriate value and not one that is arbitrarily large.

For more information, refer to the SET BLOCKFACTOR documentation.