RBS,

> We will be moving from IB 5.6 to FB and I had heard that FB should be
> faster, but sofar I haven't seen this yet.

Having used IB from v4.0 to 6.0, then FB... I can say that all FB
versions have been always faster than IB.

The only time that I have seen it to be slower is when the statement
uses SQL-89 JOIN syntax instead of SQL-92+ syntax.

SQL-89:

SELECT
...
FROM
TableA, TableB, TableC
WHERE
B_Key = A_FK
AND C_KEY = B_FK
AND ...

SQL-92

SELECT
...
FROM
TableA
JOIN TableB ON B_Key = A_FK
JOIN TableC ON C_KEY = B_FK
WHERE
...


Personally, I have always used SQL-92 (I find it easier to read).


Sean