Subject Re: [firebird-support] Firebird vs Postgres
Author Richard Wesley
On Dec 21, 2006, at 15:03, Andrew Chalk wrote:

> Have you speed-tested FB2 vs. MS SQL Server 2005 Express Edition. I
> would be
> interested in knowing how these two free databases compare.

I have not done any benchmarking of SQL Server X, partly because it
is the same code base.

We evaluated SQL Server X for our embedded engine rejected it because:

- The database size has been crippled to 2G
- The installer requires .NET (and installs it).
- The footprint is 50G

Not to be totally negative, I should list the advantages:

- Mature, well understood
- Able to store databases in a single file
- Full set of built in functions with correct NULL handling (unlike
FB...)
- Sophisticated collation support (better than FB)
- Great performance (better than FB)
- My office mate use to be on the SQL Server dev team ;-)

HTH
________________________________________________________
Richard Wesley Senior Software Developer Tableau
Software
Visit: http://www.trytableau.com/now.html