Software performance investigation vs throwing more hardware
News via Patrick Pierson‘s blog
I found this link on reddit under /r/sysadmin. Josh Hartmann has a customer that had slowness issues with a database server. Josh contacted the developer and every time the developer’s response was to add more hardware to the problem. After some investigation he found a few issues with the developer’s setup of the server, fixed it and now his customer is happier then ever. Here is his write up, great stuff.
Loading...
Oh well… I totally agree that several software development companies using Firebird really doesn’t know (or care) about using/configuring it in the right way (I’ll not even talk about transaction control, heheh).
But reading his article, I see some of his optimizations is still not the best. Using SuperServer with no Firebird cache?!
Also, even using CPUAffinity, FB 2.5 SS will only use more than one core if there are more than one database file being used at the same time (it is not clear if this is the case there).
Afaiu, he also failed to understand the “cache” bug… it is not a firebird bug, but a “lack of intelligence” of Windows cache (it was Windows OS cache who was consuming all the RAM), as Dmitry Yemanov described very well in his blog.
The best is to give reply to the original article
Done.