#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2003
    Posts
    2
    Rep Power
    0

    Question Firebird vs Interbase speed


    Hi all,

    I really would like to know if Fierbird is faster than Interbase, and if so, how much. I've read somewhere that FB uses memory to perform temporary sorts, and I guess that would lead to huge speed benefits.
    I have been deploying Interbase 6.01 with my apps, but I've been looking into the possibility of switching to Firebird. My apps make heavy use of SPs and triggers, and would benefit from extra speed.

    Thanks in advance
  2. #2
  3. Bug Hunter
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2003
    Location
    Transylvania (Romania)
    Posts
    309
    Rep Power
    24
    Hmm from what i know (better optimizer) firebird 1.5 is faster than ib6.0.1 and Firebird 1.0.3 . But is better to do a test first . I think is not so hard . You take the backup from ib6.0.1 and make a restore on firebird and after that you can try it .
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2004
    Posts
    3
    Rep Power
    0

    FBv15 vs IBv71 on dual xeon pc


    Hi all.

    We bought a new server because the old one is too slow yet. The FBv15 not support SMP so we decidet to buy an IBv71. Before we buy it, we got a trial version for testing.
    And the result of the test is inpossible...
    Test pc 1: FBv15 on winXP and amd 1500++
    Test pc 2: IBv71 on linux and dual xeon (p4)

    The first 2 task of my testin procedure is:
    1: create database
    2: extract metadata

    Both test was double faster on FB than IB. eg: test 1 lasts 60 secs on IB but 30 secs on FB!

    How can FB much faster than IB and how can AMD 1500++ faster than IBM dual xeon??

    Thanks
  6. #4
  7. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2004
    Posts
    1
    Rep Power
    0
    Hi all,

    Anyone have conditions to sendme a web page with comproves a FB server dont support SMP ?
  8. #5
  9. Modding: Oracle MsSQL Firebird
    Devshed Supreme Being (6500+ posts)

    Join Date
    Jun 2001
    Location
    Outside US
    Posts
    8,527
    Rep Power
    539
    FB superserver does not support multiprocessor machines, use classic server instead (process based), you can read this in your firebird.conf:


    # ===========================
    # SuperServer Engine Settings
    # ===========================
    #
    # ----------------------------
    # Which CPUs should be used (Windows Only)
    #
    # In an SMP system, sets which processors can be used by the server.
    # The value is taken from a bit map in which each bit represents a CPU.
    # Thus, to use only the first processor, the value is 1. To use both
    # CPU 1 and CPU 2, the value is 3. To use CPU 2 and CPU 3, the value
    # is 6. The default value is 1.
    #
    # Type: integer
    #
    #CpuAffinityMask = 1
    BTW I've done some benchmarking with Apache's JMeter between Firebird 1.5 and MySQL 4.0.17 with large selects and ... well ... MySQL is faster.
    Last edited by pabloj; August 3rd, 2004 at 10:59 AM.

IMN logo majestic logo threadwatch logo seochat tools logo