agusdwikarna wrote:

> I've tried Firebird in 2005, as a candidate to replace our company's
> SQL Server 2000 databases. At that time I found that Firebird's left-
> outer-join was slow compared to SQL Server 2000 (or was it not
> natively supported?

LEFT [OUTER] JOIN is and way supported, and it was as quick as MSSQL2000
when proper indexes are used. The main problem was Firebird's query
optimizer which didn't do the job very well.

> Now in 2007, how is Firebird's left-outer-join compared to SQL Server
> 2000/2005 and MySQL 4.x/5.x ? Faster, slower, or about the same?

Again, it all about optimizer. It has been improved a lot, so you should
really try our Firebird 2, and see what you get. If it's still slower,
don't give up that easily: post the execution plans for the 'slow'
queries and we can help you to improve them (by adding indexes, or
rewriting), to make it on par with MSSQL or MySQL.


--
Milan Babuskov
http://www.guacosoft.com
http://www.flamerobin.org