September 16th, 2003, 08:29 AM
Firebird vs Interbase speed
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
September 19th, 2003, 03:25 PM
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 .
FBv15 vs IBv71 on dual xeon pc
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??
August 3rd, 2004, 08:32 AM
Anyone have conditions to sendme a web page with comproves a FB server dont support SMP ?
August 3rd, 2004, 09:56 AM
FB superserver does not support multiprocessor machines, use classic server instead (process based), you can read this in your firebird.conf:
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 09:59 AM.