| Subject | RES: [firebird-support] Firebird 1.5 on 64bit OS. Newer Hardware but bad performance |
|---|---|
| Author | Fabiano - Desenvolvimento SCI |
| Post date | 2014-05-30T15:38:05Z |
Maybe you dont have a HDD cached controller.
Run a program like Crystal Disk Mark in the old computer and in the new computer. If the performance of new computer is terrible you must change your physical hard disk controller.
I had this problem with a Dell server that is a “internet server” (without cache) instead of a “Database serve”.
De:
firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Enviada em: quinta-feira, 29 de maio de 2014 21:42
Para: firebird-support@yahoogroups.com
Assunto: [firebird-support] Firebird 1.5 on 64bit OS. Newer Hardware but
bad performance
We recently upgraded our database server from Win server 2003 to Win 2008 server. We upgraded hardware as well.
The new hardware (IBM x3550 M4) is way more advanced than the old one. 4 times the RAM and CPU speed.
We ran some tests on the new hardware(a few select/update queries), the performance was way less than the old server using the same database.
I read somewhere on one of IB Surgeon slides that All architectures of 32 bit Firebird will work bad at 64-bit Windows with >4Gb RAM.
Since we can't upgrade our Firebird DB to 2.x, Do we need to downgrade our OS to a 32 bit version and install less RAM to gain a little more performance or we missing something else?
Thanks,
-Halim