I am not sure if this is right place to post. IB/Firebird is one of
the best in term of easy to manage, stability and standard feature
support.

One thing is that always forces me to think about moving to other
database such as MS SQL or ORACLE is the query speed in IB/firbird,
especially with sub query.

As our application needs to support all major industry database (MS
SQL, ORACLE, db2 etc) in the same code base, it is difficult to use
IB-Specific "NON-STANDARD" PLAN feature to speed it.

Any plan from atchitect point of view to addres optimization issue. I
believe that it shoudl be the top priority after firebird1 out before
adding new features.

This is just my thought. Any comments?

jw