| Subject | Re: [firebird-support] Firebird performance question |
|---|---|
| Author | Alexey Kovyazin |
| Post date | 2014-10-02T08:14:08Z |
If your application and database are the same and and you using them in the same manner with the same Firebird configuration (http://ib-aid.com/en/optimized-firebird-configuration/), the difference in performance is always explained by hardware - either hardware problem (like absence of BBU on RAID) or absence of necessary (modern) drivers.
Moreover, 2008r2 has the same core as W7, and even can be tuned to look and act like W7:
http://www.win2008workstation.com/
If you want more detailed answer, you should provide exact details, according the questions here
http://ib-aid.com/required-information-for-firebird-database-performance-optimization
Regards,
Alexey Kovyazin
IBSurgeon
Hi,
We have been using Firebird Super Server version 1.5.6 on both Windows 7 (64 Bit) and Server 2008 (64 Bit). Both systems are the same except for the OS and they have 2 CPUs and about 4 gig of RAM. We have noticed that any applications, with large multiple writes, is much faster on Windows 7 than on Server 2008. I know there is newer version and we are planning to upgrade the Firebird, but is there something missing on 2008 that would improve the performance. Also, when we upgrade to version 2.5, would we see similar performance between Windows 7 and Server 2008?
Thanks,
Bill
Bill Newhall | Technical Director | MedAssets
153 Cordaville Rd., Suite 110 | Southborough, MA, 01772 | Work: 508.460.8524 | Mobile: 617.515.3073 | Fax: 508.460.8539
bnewhall@...
Visit us at www.medassets.com
Follow us on LinkedIn, YouTube, Twitter, and Facebook
*****Attention*****
This electronic transmission may contain confidential, sensitive, proprietary and/or privileged information belonging to the sender. This information, including any attached files, is intended only for the persons or entities to which it is addressed. Authorized recipients of this information are prohibited from disclosing the information to any unauthorized party and are required to properly dispose of the information upon fulfillment of its need/use, unless otherwise required by law. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon this information by any person or entity other than the intended recipient is prohibited. If you have received this electronic transmission in error, please notify the sender and properly dispose of the information immediately.[Marius Labuschagne]
Hi Bill, I don’t have the answer, but will also keep an eye on this question.
What I can tell you as that I am running my Client sites on 2.5.3 Superserver, some Clients with 2008 Server, and some using Desktop machines with Windows 7 on it as Server machines.
And without fail the Windows 7 machines outperforms the 2008 Server machines by magnitudes. There are a lot of discussions you can find about this, but I was not able yet to find a solid solution to this problem.
Regards
Marius