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

    Join Date
    Mar 2004
    Posts
    20
    Rep Power
    0

    Resource Utilization ???


    Hi,
    I am working on an Linux Appliance which will have 128MB RAM. Currently the application is written using MySQL. But its limited functionality (no support for Views, Stored Procedures, Sub Queries etc.) is forcing us to go for some other database. I am looking FireBird as a replacement candidate. But my concern is the resouce utilization and data corruption. MySQL is very lightweight and we never faced any data corruptions after reboots etc.

    Does anybody have any idea about resource utilization of FireBird vs MySQL ? And how good is FireBird in the event of systems reboots etc.?

    Regards:

    Joga Singh
  2. #2
  3. Bug Hunter
    Devshed Newbie (0 - 499 posts)

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

    Arrow


    Here are my results from top command for firebird 1.5

    VIRT RES SHR COMMAND
    3548 1336 3164 fbguard
    27208 2956 5700 fbserver

    I'm shure the fbserver can be tweaked to use less memory
    As for the reboots firebird handle quite well the reboots . You should test it:
    Install firebird on a machine and do the real test. (Reboot it)

    ps:
    The results are from an AMD Duron @1933Mhz 1G Ram (ddr400) os: fedora core 2
    At home i have an p166Mhz (rh8.0) and 80M memory (edo - ram) Fbserver works on that machine
    I even managed to compile it on that !
    Last edited by mariuz; March 24th, 2004 at 03:00 PM.
    My home page: http://www.firebirdsql.org and work place :http://www.reea.net

IMN logo majestic logo threadwatch logo seochat tools logo