> You need to redo all your joins into ANSI 96 syntax

Thanks, that is what I always do in any case.



Are there any other tips to be aware of when moving come IB 5.6 to FB?



RBS



_____

From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Tom Miller
Sent: 08 October 2007 18:36
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] FB faster than IB 5.6



You need to redo all your joins into ANSI 96 syntax. Remove joining
code from the WHERE clause and put it in the FROM

FROM
MY_TABLE_1 JOIN MY_TABLE_2
ON MY_TABLE_1.KEY_FIELD = MY_TABLE_2.KEY_FIELD
WHERE

Yes FB is much faster.

In addition, you need to qualify every field in the statement of multi
table selects. Make sure the TABLE_NAME is included as part of the field.

WHERE
ZIP_CODE = '12345'

may not use an index where

WHERE
ADDRESS.ZIP_CODE = '12345'

will.

RB Smissaert wrote:

> We will be moving from IB 5.6 to FB and I had heard that FB should be
> faster, but sofar I haven't seen this yet. I understand a major weakness

of

> IB 5.6 is the poor plan generator and I wonder if this is any better in

FB.

> Are there any comparisons between these 2 available somewhere or any
> comments otherwise?
>
> RBS
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebird <http://www.firebirdsql.org> sql.org and click

the Resources item

> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoeni

<http://www.ibphoenix.com> x.com

>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>

[Non-text portions of this message have been removed]