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 course in Czech

Based on numerous inquiries and wishes of our readers (dbsvet.cz), we decided to organize a one day dedicated to the Firebird database platform, which spells out why the Firebird is a good alternative for the development of new database applications.

One-day course about Firebird led by leading Czech expert (Jiri Cinkura) on this issue introduces the basic database features Firebird so that each of the participants recognized the advantages and disadvantages of this platform for developing real applications and testimonials.

AnySQL Maestro 9.8 released

AnySQL Maestro SQL Maestro Group announces the release of AnySQL Maestro 9.8, a powerful tool to manage any database engine accessible via ODBC driver or OLE DB provider (Access, SQL Server, Firebird, Oracle, MySQL, PostgreSQL, etc). Key features include graphical database designer, visual query builder, data export and import, BLOB Viewer/Editor, and a lot of other things.

    AnySQL Maestro has been successfully tested with Firebird ODBC drivers 1.xx and 2.0 RC1 and all the latest Firebird server versions up to 2.5 Beta 2.

    #Slackware #Linux #Slamd64 and #Firebird

    Here is what Milan Babuskov wrote about his experience with Linux Slackware and Firebird related packages on x64 system :

    I just installed Slamd64 version 12.2. I know that Slackware -current is 64bit and Slackware 13.0 is out, but out-of-the-box 32bit compatibility of Slamd64 is very tempting, so this is the first 64bit slackware I installed.
    Install went fine, and KDE is running in a matter of seconds. Now, time to compile all the needed stuff for development. Basically, all I need is Firebird, FlameRobin and PHP extension for Firebird (i.e. InterBase).

    1 4 5 6 7