>The query optimiser was certainly changed. Some might say for the worse.
>The
>main improvement, introduced in v5, was the handling of SQL-92 JOIN
>statements. Previously you had to do joins using the WHERE clause to get
>reasonable performance. So unless you have been a stickler for SQL-92
>conformance you will not be using JOINs anyway.

v4 does understand 'select .. from taba inner join tabb on ...'

>Overall you may see some performance improvements in some areas. However, I
>would look at pitching other benefits too, such as bug-fixes, dialect 3,
>int64
>(for financial apps), larger page sizes (another possible perf. tweak),
>64-bit
>file i/o etc. Borland's site should have docs outlining all the new
>features
>in v5 and v6. And the release notes for FB 1.0 on sourceforge have the new
>features of Firebird. All in all a lot of things are there to make the
>switch
>worthwhile.

all the users see is the performance (currently not great) and
the reliability (fine), all the other items above are great technically but
the users will never see them


_________________________________________________________________
Join the world�s largest e-mail service with MSN Hotmail.
http://www.hotmail.com