Modify engine to open GDB files for exclusive access. Currently, the server opens files for shared access, even though it should never share access. The result is that different variations on a name may be attached as different databases. The server holds lock tables for each variation and ultimately this results in corruption. Disable Requirement for foreign keys to create indexes.
Foreign keys pointing to small lookup tables have low selectivity.
They really shouldn't confuse the optimiser, but they do, leading to queries that perform more slowly than they need. The work for this is well underway. It will be interesting to see the performance benefits. Bugs already fixed A list of bug fixes already applied can be viewed here on the Firebird Web site. Some, but not all, will have been fixed for the current release of Firebird.