Subject | Re: [firebird-support] Required information for Firebird database performance optimization |
---|---|
Author | Alexey Kovyazin |
Post date | 2014-02-18T19:13:14Z |
Hi Hannes,
Good point, thank you - I added it.
Regards,
Alexey Kovyazin
Good point, thank you - I added it.
Regards,
Alexey Kovyazin
Guten Tag Alexey Kovyazin,
nice Questionaire , i would suggest to add 1 more point
if it has a Raid then the size of the Stripe Set
The Stripe Set ist the amount of data a raid moves to / from the diskarray for every read/write.
Example:
a Raid 5 with 3 Disks and a Stripset of 128 KB means that each Read / Write will move 192 KB
now add a Database Page Size of 4 KB (Worst Case)
then every database page read or written will instead move 192 Kb or a 48 fold overhead