Subject Re: Embedded on a web site
Author bouncybumble
--- In firebird-support@yahoogroups.com, Elmar Haneke <elmar@...> wrote:
>
<snip>
> In practise it would be absolutely preferrable to install the server:
>
> - it does not make sense to initialize DB engine on each request
>
> - I would not expect embedded to be stable and performant in an
> multiuser scenario.
>
> Elmar
>

I would refute that statement. I am using the 2.5 embedded server in a small load web service (100-200 requests per minute) and have had no problems with performance so far. The app (.NET) uses connection pooling so there is limited connection initialization and multiple connections are processed without any issues I have found yet.

FWIW, I am also running a web application with a full server implementation installed and between the two systems I see no difference.

The real advantage for me is that I can easily deploy my web application without installing and running a separate service/daemon.

Regards,
Frank