Just to add my experience. We tried version 2.0 and decide to stick to
1.5.3. Several queries performed worst in version 2.0. Checking the
query plan we noticed that index used by 1.5.3 where not being used in
2.0. If enforce its use than version 2.0 performs a little bit better
than 1.5.3. But we could not afford to check every query for tuning.
Also the gain is marginal.

Best regards,
Eduardo Mauro
www.connectedtext.com

On 8/4/06, Andrew Guts <developer@...> wrote:
> Thank you. I've got several good advices here. Now the query performance
> is acceptable.
>
> Andrew.
>
> Dmitry Yemanov wrote:
> > [re-sent]
> >
> > Andrew,
> >
> > This is one of the cases where it's hard to improve something without making
> > something other worse :-) The new v2.0 cost estimation algorithm considers
> > indices on s.type_id and l.action_id worth using, whilst FB 1.5 ignored
> > them. And in this case 1.5 was more correct, unfortunately. I don't see any
> > easy way to fix this situation, so the only good solution for 2.0 would be
> > "hints" like:
> >
> > s.type_id+0 = i.type_id
> > -- and
> > l.action_id+0 = a.id
> >
> > that disable usage of the "bad" indices.
> >
> > We'll try to fix/enhance the cost estimation rules in the next version, so
> > it would perform better in such cases.
> >
> >
> > Dmitry
> >
> >
> >
> > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> >
> > Visit http://www.firebirdsql.org and click the Resources item
> > on the main (top) menu. Try Knowledgebase and FAQ links !
> >
> > Also search the knowledgebases at http://www.ibphoenix.com
> >
> > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> >
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
> >
> >
> >
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>