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.

Firebird is #1 with Delphi

Wings of Wind blog talks about Firebird support requests for Delphi, with interesting numbers:

The main complaint of some folks was about (lack of) support for their favorite database engine. As perhaps, you know, in this release there is no official SQLite and PostgreSQL support. Well, giving in account that we have already a new DBX driver in this version (Firebird) and the number of votes for PostgresSQL and SQLite compared with the ones for the Firebird DBX driver (which was #1 in QC with more than 1000 votes on all reports – duplicates, variants etc.) is a quite expected result.

(…)

Firebird + MS SQL + mySQL accounts more than 50% from your preferences with Firebird as clear leader. (MS SQL + mySQL = Firebird percentage). Closely follows Oracle and Access (!). Now, with the acquisition of SUN the things (perhaps) will change.

(…)

Also we see a bunch of Firebird/Interbase solutions which are high in ranking: FIBPlus, and a little bit lower IBX and IBObjects almost in par.

Check the full post, including nice graphics.

Embarcadero Extends Upcoming Delphi 2010 Release with Firebird SQL

The latest sneak preview showcases expanded database connectivity for more than a dozen platforms including Oracle, Microsoft SQL Server, Sybase, MySQL, InterBase, IBM DB2, and more, plus new support for the popular Firebird SQL database (…) “The 2010 releases will add highly requested support for Firebird SQL, the popular open source database which is based on Embarcadero’s InterBase database platform.”

Read full article at JDJ.

1 44 45 46 47 48 100