Category: General news

Firebird related news

CPU suggestions for Interbase/Firebird SQL db server

One comment

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

Leave a comment

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

Leave a comment
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.

    New IBProvider 3.0.0.7575 with queries pool and enhanced working with Delphi.

    Leave a comment

    Performance optimization for repeated queries
    New IBProvider v3 has the pool of SQL-queries that stores prepared and created commands and allows substantial time saving with a large number of repeated queries for Firebird.

    Support of tables list getting in Delphi in Client Cursor Engine mode
    Tables list getting has been brought into compliance with the requirements of dbGo components in Client Cursor Engine mode.

    Attention! Special offer!
    20 % discount for any IBProvider license is valid for 4 days only.

    Please read details here: query pooling in Firebird

    Linux/s390x support for Firebird 2.1.2

    Leave a comment

    Dan Horák wrote on firebird devel list:
    I am a Fedora and Red Hat Enterprise Linux developer and we are now
    porting whole Fedora package collection to the s390x (IBM System z a.k.a
    mainframe) architecture. The official sources for Firebird (in version
    2.1.2) didn’t support this architecture, so I have prepared a patch that
    adds this support. Please let me know what else should I do to get the
    support accepted into the official source tree.

    the patch was uploaded to
    http://tracker.firebirdsql.org/browse/CORE-2559

    successfully built Fedora-11 package is at
    http://s390.koji.fedoraproject.org/koji/taskinfo?taskID=83287

    1 … 149 150 151 152 153 … 205