delphifirebird-embedded

Does Firebird 3 embedded server have major disadvantages?


Are there major disadvantages using the embedded Firebird 3 in a multi-user application server (Delphi Webbroker) instead of the full blown server install?

The application usually has very short transactions with low data volume.

As far as I am informed accessing one database file with multiple threads through the embedded server is not problematic but user security is not available. As the application server does the rights stuff I do not need Firebird security.

But will I loose performance or things like garbage collection?


Solution

  • Firebird Embedded provides all the features (except network access and authentication) that a normal Firebird server provides. However, because it is in-process, any problems that cause your application to crash, will take Firebird with it and vice versa.

    Other possible downsides:

    Personally, I would only choose Firebird Embedded if the situation calls for it. In all other situations, I will use Firebird Server.