--- In firebird-support@yahoogroups.com, "Alan McDonald" <alan@m...>
wrote:

> groups.com
> > Subject: [firebird-support] Firebird 1.5.0 or Firebird 1.5.2 for Linux
>
> there's probably a knat's ball hair between them - see if you can

find which

> one.
> Alan
>
> >
> >
> > which is the fastest ?
> >
> > ----------

The sub versions are not about new features and optimisations, they
are predominantly bug fixes. In particular, a GBAK issue with large
BLOBs was fixed.

1.5.2 should go faster in certain queries, eg

SELECT *
FROM RDB$RELATIONS r
LEFT JOIN RDB$RELATION_FIELDS rf
ON (1 = 1)
WHERE
r.RDB$RELATION_NAME = rf.RDB$RELATION_NAME

1.5.0 PLAN JOIN (R NATURAL,RF NATURAL)
1.5.2 PLAN JOIN (R NATURAL,RF INDEX (RDB$INDEX_4))

But may go slower in others. There are two reasons it may go slower.
Either a bug was unintentionally introduced (I would be looking at the
upcoming 1.5.3 and 2.0 release notes for any details), or an
"optimisation" that was done in 1.5.0 was actually a bad idea, and may
have given the incorrect result.

But I have found in practice very little measurable performance
difference between the versions.

Adam