--- In IBObjects@y..., Raymond Kennington <progsol@c...> wrote:

> > Can I make the Query to skip this? Becuase sometimes I only want

to

> > run a very simple query, I don't need these metadata. I am afraid

my

> > client will not accept the initial delay.
> >
>
> Part of the delay is in determining the PLAN(s).
>
> Here's an idea that others will tell you not to do, but has cut the

preparation-time of queries significantly for me

> with IB 5.
>
> Work out the optimal PLAN for each query and provide it explicitly

in the SELECT statement.

>
> To do this, start with the PLAN that is provided by the tool you

are using to see what PLAN would currently be used.

> Mostly, this is the correct PLAN to use. Try this and if it speeds

up the preparation then use it.

>
> For complex queries with JOINs and nested SELECT statements the

PLAN provided by the above step was sometimes completely

> wrong (with IB5). Then you'll have to work them out by analysis of

the JOINs and sub-SELECTs.

>
> Please post your results.
> --
> Raymond Kennington
> Programming Solutions
> W2W Team B

I tried putting the PLAN into the SQL statement but it doesn't help.
I believe the PLAN is not eating my time because it worked very fast
locally. So I suspect it generate too many traffic when asking for
metadata.

Rgds,
Michael