Firebird vs Interbase speed

Hi all,

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

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 .

Hi all.

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

Hi all,

Anyone have conditions to sendme a web page with comproves a FB server dont support SMP ?

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.