Thread: benchmarks?

    #1
  1. Capt'n
    Devshed Novice (500 - 999 posts)

    Join Date
    May 2001
    Posts
    567
    Rep Power
    15

    benchmarks?


    Has anyone done any benching of firebird vs. PostgreSQL or MySQL? I have the older Interbase 6 on my old Raq2 at home here, what are some of the differences between interbase and Firebird?
    Why? Because Forms just look cooler in OS X...

    Dutch, it's like German...but not!
  2. #2
  3. Big Endian
    Devshed Beginner (1000 - 1499 posts)

    Join Date
    May 2001
    Location
    Fly-over country
    Posts
    1,172
    Rep Power
    30
    Has anyone done any benching of firebird vs. PostgreSQL or MySQL?
    I haven't been able to find any rigourous formal testing of these databases in a head-to-head matchup. I came across one site where a guy took his workstation and compared MySQL, Postgresql, Firebird and Oracle 8 doing a bunch (50~100k) of inserts and selects. As would be expected, MySQL in single-user mode was almost twice as fast as the other databases. Firebird was 2nd/4th, Postgresql 3rd/3rd and Oracle 4th/2nd but all three of them were very close to one another.

    This "test" was very unscientific and just showed that a basic installation of these databases doing a simple repetitive task with a single user that MySQL was fastest and the other three were comparable. Trying to extrapolate this into something meaningful in the real world would probably be bogus.

    I have the older Interbase 6 on my old Raq2 at home here, what are some of the differences between interbase and Firebird?
    Firebird 1.0 = Interbase 6.0 (except Firebird fixed some of the IB bugs). They're the same code base.

    FB 1.5 and IB 7.0 aren't identical because Borland isn't sharing the 7.0 code. Here's the changes that went into FB 1.5. The list is in reverse chronological order so the enhancements are near the bottom while most of the bug fixes are at the top.

    http://cvs.sourceforge.net/cgi-bin/v...viewcvs-markup
  4. #3
  5. Bug Hunter
    Devshed Newbie (0 - 499 posts)

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

    Tell me what you want to test ?


    I have all installed on a box mysql-server-3.23.52 ,postgresql-7.2.2,Firebird 1.5 rc2
    I can make a 1Milion inserts/select into a simple table and show you the results , Also we can
    test even some joins .
    Later we could try some other benchmarks
    http://osdb.sourceforge.net/
    And in my plans is this test too (we need a port on firebird... )
    http://www.osdl.org/projects/performance/

    PS: but from what i have seen on firebird developers lists the v1.5 screams compared to the v1.0 or ib6.x (we got a better optimizer)
    Last edited by mariuz; May 29th, 2003 at 08:29 AM.
    My home page: http://www.firebirdsql.org and work place :http://www.reea.net
  6. #4
  7. Big Endian
    Devshed Beginner (1000 - 1499 posts)

    Join Date
    May 2001
    Location
    Fly-over country
    Posts
    1,172
    Rep Power
    30
    It might be interesting to look at the firebird-benchmarks and see what they do: http://sourceforge.net/project/showf...?group_id=9028

    Then there's the MySQL "crash-me" benchmark: http://www.mysql.com/doc/en/MySQL_Benchmarks.html

    I've never performance tested database servers before, so I don't know how much work is involved. Also, unless you know something about the quality of the test, it's hard to quantify the quality of the results. A lot of the tests I see measure how fast a database can repeatedly do the same thing like an insert. They're a single-user test. But Microsoft Access could probably insert records fast enough for most of my needs. I'm more interested in concurrent users. At what threshold do the databases start grinding down as you add more users who are hammering it. Unfortunately very few people have the hardware and the time to do this kind of testing.

    On the other hand, like driving a fast car, sometimes it's fun to race even if the final results don't mean much anyway.

IMN logo majestic logo threadwatch logo seochat tools logo