#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2003
    Posts
    10
    Rep Power
    0

    Smile How stable is firebird


    Hi, We have just started moving all our MS SQL projects to FireBird. Maily becuase of the possibility of emmbeding the database and ease of installation of maintenance.

    Is there anyone who wants to share with us experience on how robust this databse is?

    Any problems we might encounter etc etc
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2003
    Posts
    249
    Rep Power
    14
    Hi,

    Short answer: VERY stable.

    Long answer(s):
    - It becomes slowish if you (very) long running transactions, so be sure to do a COMMIT, even after a SELECT.

    - Better make sure everyone is logged out when doing changes to metadata, like updating a Stored Procedure, because it uses a metadata cache.

    - If you use UDFs (external functions), be sure they are thread safe and you're using the Firebird memory manager to allocate your memory (when using FREE_IT in the UDF declaration).


    As for the rest, what problems do you expect?
    Martijn Tonies
    Database Workbench: developer IDE for Firebird, MySQL, InterBase, MSSQL Server and Oracle
    Upscene Productions
    http://www.upscene.com
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2003
    Posts
    10
    Rep Power
    0
    Thanks a lot for your quick reply. Actually we have already started seing it. Today we converted our QBLink previously in FlashFiler from Tourbo Power (if I am not mistaken) This link works as a bridge between Retail Pro and QuickBooks. Its working really great. I mean we have tested with a 10 sec update shedule and inbetween we have the FirBird as the database. And it works as if its one application accessing one database.

    All your ideas noted and passed on to programmers.
  6. #4
  7. Modding: Oracle MsSQL Firebird
    Devshed Supreme Being (6500+ posts)

    Join Date
    Jun 2001
    Location
    Outside US
    Posts
    8,527
    Rep Power
    539
    Hi, be aware that Firebird (and Interbase previous to version 7) do not take any advantage out of SMP servers, so if you want to speed up things buy a faster CPU, more RAM, faster disks but not a dual CPU server, it would simply be a waste of money.
  8. #5
  9. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2003
    Posts
    249
    Rep Power
    14
    Not entirely true.

    Firebird comes in two architecture flavors:
    - SuperServer
    - Classic

    The "classic" architecture spawns a process per connection and therefore takes advantage of multiple CPUs, the "superserver" doesn't, but has a shared (data) cache for connections to the same database.
    Martijn Tonies
    Database Workbench: developer IDE for Firebird, MySQL, InterBase, MSSQL Server and Oracle
    Upscene Productions
    http://www.upscene.com
  10. #6
  11. 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 Upscene and Pabloj!

    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
  12. #7
  13. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2003
    Posts
    249
    Rep Power
    14
    Both tasks are not really a decent test. Why does "creating a database" need to be very fast? Why does extracting metadata need to be very fast?
    Martijn Tonies
    Database Workbench: developer IDE for Firebird, MySQL, InterBase, MSSQL Server and Oracle
    Upscene Productions
    http://www.upscene.com
  14. #8
  15. Modding: Oracle MsSQL Firebird
    Devshed Supreme Being (6500+ posts)

    Join Date
    Jun 2001
    Location
    Outside US
    Posts
    8,527
    Rep Power
    539
    Hi, please reread what upscene wrote:
    Firebird comes in two architecture flavors:
    - SuperServer
    - Classic

    The "classic" architecture spawns a process per connection and therefore takes advantage of multiple CPUs, the "superserver" doesn't, but has a shared (data) cache for connections to the same database.
    So I think you can save money and use Firebird 1.5 classic server (download here) on your new 2 CPU machine.
    BTW I'm pretty shure that the 2 CPU machine is faster when many users are performing many queries at the same time (load spread on two CPU) and not when doing a single task under one connection only.
    Again, if Firebird has showed to be more efficient, why buy Interbase?
  16. #9
  17. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2004
    Location
    Cape Town, South Africa
    Posts
    51
    Rep Power
    11

    FireBird Classic vs SuperServer


    Hi

    I don't understand! SuperServer does not make use of multiple CPU's!!

    I Beleive you but that's crazy!

    The word Super Server suggests that it should be better than the classic installation.

    So what is the actual benefit of having the SuperServer option?
  18. #10
  19. Modding: Oracle MsSQL Firebird
    Devshed Supreme Being (6500+ posts)

    Join Date
    Jun 2001
    Location
    Outside US
    Posts
    8,527
    Rep Power
    539
    So what is the actual benefit of having the SuperServer option?
    It's more efficient on single CPU machines (and on OSs that rely on threading or anyway have a good thread implementation).
  20. #11
  21. Bug Hunter
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2003
    Location
    Transylvania (Romania)
    Posts
    309
    Rep Power
    24

    Telecom examples are good ? :)


    Originally Posted by mohdali
    Hi, We have just started moving all our MS SQL projects to FireBird. Maily becuase of the possibility of emmbeding the database and ease of installation of maintenance.

    Is there anyone who wants to share with us experience on how robust this databse is?

    Any problems we might encounter etc etc
    Here are some examples from firebird-general list

    In Firebird-general (at) yahoogroups Dalton Calford wrote:

    When we started to provide flat rate charges for all long distance in
    each province (averages 1.8 cents a minute) our processing requirements
    and infrastructure load jumped dramatically. We had to scramble to
    upgrade systems, replace switches, upgrade customer service needs, we
    had our hands full..... except when it came to our database systems. We
    added a few more external raid arrays and added some extra files to our
    file list. Painless.

    Firebird is more than capable of being a data warehouse production
    server. It is even used as a embedded control database in our SS7
    network switches which are rated for five9's reliability.


    I do not think we are the only company using Firebird for such
    environments, as such, you would probly be extreamly supprised by the
    number of people who use it daily without knowing.

    best regards

    Dalton
    Another post
    Hi Pradeep,

    Large databases are not a problem, nor will you have problems with the
    database being very active.
    We have a 24/7 database system that supports multiple remote offices,
    well over 300 concurrent active users and automated interactive voice
    systems that query and update the database. The database is updated
    with customer call records that are starting to exceed 5GB a month in
    call volume.

    ..............
    Dalton


    Pradeep wrote:


    >>Hi,
    >>We are developing a data warehousing solution for a telco. We used SQL
    >>server 2000 for proto and pilot project before moving onto Oracle on Unix.
    >>And our experience with SQL server 2000 was NOT good.
    >>So, I was wondering whether Firebird could be a good choice when it
    >>comes to building data-marts if not full fledged datawarehouses?
    >>
    >>Thanks in advance,
    >>Pradeep
    >>
    >>
    >>
    >>
    >>
    Last edited by mariuz; May 18th, 2004 at 02:22 AM.
    My home page: http://www.firebirdsql.org and work place :http://www.reea.net

IMN logo majestic logo threadwatch logo seochat tools logo