Wow, five years of IB 6.0.2.0! At my workplace, we never even used IB
6.0, we changed from IB 5.6 to Firebird 0.9.4 in our production
environment. Though, if you don't use the database too much, I suppose
IB 6.0 could suffice.

As Helen said, there are lots of bug fixes since IB 6.0 - as well as
additions of new features. In short, I'd say that Firebird is generally
much less prone to errors than IB 6.0, but then I'm talking about less
prone to errors from both the engine itself and the programmer writing
programs using IB/Fb. If your program(s) are badly written, odds are
that what worked in IB may give a syntax error in Fb. IB 6.0 tried to
understand what the programmer wanted and gave results that may be
correct, incorrect or simply different from what was intended. Firebird
generally insists on code being unambiguous. With a well written
program, I think that any version of Firebird at least since version 0.9
is superior to IB 6.0.

If your question is whether you should go for Firebird 2.0 or InterBase
7, then I cannot answer - I have no experience with InterBase 7 and
don't know where to find a comparison. However, given that you've used
IB 6.0, I'd say the question is similar to ask whether you should by a
new computer with an AMD or Intel processor when you're used to a six
year old computer. The answer is of course that whatever you choose will
be a lot better than what you have today.

New features have of course also been introduced in Firebird 1.5 and
2.0, but if you're considering changing from IB 6.0, I'd say that's
bonus to be investigated once you get your existing programs up and running.

Set

Jack Mason wrote:

> We have been using IB 6.0.2.0 for about 5 years and are beginning to use
> the new dual core hyperthreaded processor boards on which it will not
> run without using the IBAffinity program. Is there a place where we can
> see a comparison of IB and Firebird?
>
> Thanks