Q&A
Optimal block size in raid set for Hansa.hdb
9-23-21
Operating system: macOS
Hello,

We are launching new server on MacOS 11.6 with 8 SSD disks in Raid 10. It will be used as a Standard ERP server.
We were wondering what disk block size uses Standard ERP for the database? Or just what block size shall we set to have maximum performance for the database?


Can anyone advise?

Regards,
Damian Czuchajewski
Independent Proxy.
Ekkom.
Reply
Erik Elmgren
9-28-21
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.
Reply
10-18-21
Created byErik Elmgren10:12 28 Sep 2021
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 m
Thank you for your reply.

Regarding RAM size.... can you advise what RAM size and --db-cache=?G parameter would provide best performance of importing text backup of database which has 120 GB?

Regards.
Reply
Bror-Erik Kotiranta
11-2-21
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
Reply
Leave Comment
You can subscribe to notifications for this post by selecting the 'star' icon on the top right corner of the post.
Back to the list
Latest Posts
Re: Order Classes and automatic Activities for Service Orders
Carolina Valentino
are the activity set as Hansamanuals said? https://www.hansamanuals.com/main/mailnumber___62526/theconf___231/manuals/version___20250224/langcode___es/hwconvindex.htm?shortcode=HW0301SETTINGS_Order...
17:20 4 Apr 2025
SendAsyncWebRequest vs SendWebRequest
Paul Timms
SendWebRequest3 is a boolean function, so if this returns true and the reply header has an accepted status, you can assume that the data was sent successfully and perform some actions on the record th...
11:12 4 Apr 2025