Hi Set,

> "Ingres has a lot of features that my customers need. Firebird is not
> able to give them those features for now. "
>
> means. Not ever having pushed the limits of Firebird, I don't know
> much about its limitations (other than having read about people asking
> for temporary tables and the ability to stop long-running queries). It
> would be interesting to hear what people having experience with other
> databases miss in Firebird.

From a current evaluation project, some requirements missing in
Firebird 1.5.2 come up. ;-)

- Fine-granular multi-threading and SMP support
- Support for different authentication protocols like Kerberos, ...
- Full-Text search capabilities (I know, there are third-party
solutions available, but usually people I know are asking for
a built-in solution)
- Clustering (Load Balancing, Hot-Standby)
- Incremental Backup, Point-In-Time Recovery
- Cross-Database-Queries
- Gateways to other data sources (e.g. connecting to another
DBMS within a stored procedure)
- NUMERICs/DECIMALs with a precision up to 38
- Monitoring and Profiling capabilities (to see what's going
on in the database; running statements, transactions, ...)
- and some more ...


Don't know whether Ingres supports some of the features
mentioned above. Firebird 2 will have e.g. Incremental
Backup. A pitty that the monitoring stuff won't go into
v2.


Regards,
Thomas