[firebird-support] Required information for Firebird database performance optimization
Hi All, I am a bit tired of repeated topics regarding database performance, so I decided to publish short version of our performance questionnaire: http://ib-aid.com/articles/item157 I suggest to always ask people who come here with Firebird performance problems to answer these questions and send answers to the list, in order to facilitate performance problems resolution. Regards, Alexey Kovyazin IBSurgeon
Re: [firebird-support] Required information for Firebird database performance optimization
Hello, Alexey! Tuesday, February 18, 2014, 10:10:09 PM, you wrote: AK I am a bit tired of repeated topics regarding database performance, so I AK decided to publish short version of our performance questionnaire: AK http://ib-aid.com/articles/item157 These questios are also useful becase even just reading them can give an idea where the problem is or what to check in the system. For examle, we ask Is OS running as Virtual Machine instance? because, sure, any RDBMS under virtial machine will work slower than on plain hardware. :-) Of course, not that simple, but ... -- Dmitry Kuzmenko, www.ib-aid.com
Re: [firebird-support] Required information for Firebird database performance optimization
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 Hi All, I am a bit tired of repeated topics regarding database performance, so I decided to publish short version of our performance questionnaire: http://ib-aid.com/articles/item157 I suggest to always ask people who come here with Firebird performance problems to answer these questions and send answers to the list, in order to facilitate performance problems resolution. Regards, Alexey Kovyazin IBSurgeon ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ Yahoo Groups Links -- Mit freundlichen GrĂ¼ssen Hannes Streichermailto:hstreic...@gmx.de
Re: [firebird-support] Required information for Firebird database performance optimization
Hi Hannes, 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