Subject RE: [firebird-support] Embedded server
Author David Johnson
On Tue, 2006-03-14 at 12:42 +1100, Alan McDonald wrote:
> > Let me rephrase what I think you are saying:
> >
> > 1. You have an existing application that consists of a client piece
> and
> > a midware server piece.
> > 2. The client piece talks to your midware server piece.
> > 3. You want to use Firebird embedded as the backing store for the
> > midware server part of your application
> >
> > U have measured less than 5% improvement in throughput on small
> > transactions by using embedded over superserver.
> >
> > Embedded is superserver in a DLL, so it is not surprising that the
> > performance of the two models are similar. The sockets overhead is
> very
> > small, so there is not much difference between them in practical
> usage.
>
> have to disagree slightly here... use of the direct exported methods
> of the
> SS as in embedded as opposed to socket to remote server, significantly
> improves performance IME.
> Alan

Your firebird specific experience is much greater than mine. I only
actually measured the difference in one testbed application.