Helpful Information
 
 
Category: Firebird SQL Development
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?

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/viewcvs.cgi/firebird/firebird2/doc/WhatsNew?rev=HEAD&content-type=text/vnd.viewcvs-markup

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)

It might be interesting to look at the firebird-benchmarks and see what they do: http://sourceforge.net/project/showfiles.php?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.










privacy (GDPR)