SuperServer VS Embedded

Hi!!

I would like to know about the differences in the performance bettween both ways for working with firebird.

Does any body know about somebody that had tryed to work with some medium o heavy load testing tools for firebird?

Thanks

Basically they are totally different ... the Super Server is meant to stay on a server and have clients connected while embeded is meant to be used on a single PC / single user.

One difference in speed could come from this:
suppose you have a dedicated server for the database (always on) it holds some cached pages of the database (see settings in firebird.conf) allowing to make faster searches/ row fetches and so on ... while on a "normal" computer when you turn it on - NO cache.

If you plan to deploy your application on a single computer / single user I would recommend embeded dll because super server can eat up a lot of memory when it's not even needed (ex: your application is not started)

Good luck,
Silver

Difference in performance exist. Embedded is faster because of protocol used. Embedded uses Local protocol while SS uses TCP/IP.


--
Best regards,
Fikret Hasovic http://fikret.fbtalk.net
USAID TAMP Senior Programmer
* FirebirdSQL Foundation member.
- Join today at http://www.firebirdsql.org/ff/foundation
* JEDI VCS contributor
http://jedivcs.sourceforge.net/
* Firebird and Fyracle news
http://www.fyracle.org

Thanks a lot!!

It is pretty usefull