The database internal block size is 512 bytes.


The best performance for normal operations (saving records, reading records, reports, maintenances) will likely be as small a block-size as possible.

Operations such as making a copy of the database file might perform better with a large block size as these are sequential copies.

Imports of text backups is likely not affected much by the block size as long as RAM is sufficient.

Hello,

a guideline to use, is maximum of 70% of available ram on the server. But for your specific question, i have not seen any significant increase of speed after 27G cache used even if db is way larger than that