CPU suggestions for Interbase/Firebird SQL db server
I work for a small company (fewer than 10 employees). We want to upgrade our primary server hardware this year.
Current server is a HP ML330 G3 with a single Xeon @ 2.8 Ghz, 3GB ram, Raid5 consisting of three 15krpm Ultra320 SCSI drives. OS is Windows 2000 Server.
Our current CPU features hyperthreading, which is enabled. The motherboard is a dual socket board, so initially I was shopping for a second identical CPU (because they’re as cheap as $15 on eBay). But after running some tests, I don’t think it would benefit us.
Our ERP software uses Interbase version 5.6, which does not appear to be multi-threaded based on my tests. I contacted the developer of our ERP package, and they confirmed this: Interbase will NOT utilize multiple physical or logical CPUs. More recent revisions of our ERP software have switched to Firebird db server, which I’ve learned is not multi-thread aware either. This sounds terribly old-fashioned, since modern CPUs are trending toward higher core-count.
Read full post and make your suggestions here.
mmm… what a horrible news. If I remember correctly, InterBase 5.6 for Linux is Classic, not superserver, so it can utilize cores and proecessors.
Firebird have classic and superserver engines for all versions, so, I can’t understand where problem.
I’m sorry to be that suspicious, but if ERP developer can’t tell his client what version to use and which is better, something is wrong is happening with the development…