--- In IBObjects@yahoogroups.com, Helen Borrie <helebor@...> wrote:

>
> At 07:22 PM 29/10/2008, you wrote:
> >Im using IBO components in a new aplication,
> >the SELECT it's a "not simple" query , he take 150 fields from about
> >twenty Joins.
> >
> >I tested the full select in IBexpert, and it's ok and "fast" (half a
> >second) to do the prepare, but in delphi in the Tib_Query, prepare
> >take more than 8 seconds to finish.
> >
> >I try to trace a little and think the main problem it's not the
> >complexity of select (firebird resolve it fast) but the big amount of
> >fields... then? there are not solution? i must wait a non-realistic 8
> >second open the query?
> >I think the time is taked creating all internal space for 150 fields,
> >but I think 8 seconds it TO MUCH for 150 fields. May be I mistake.
>
> Certainly it will take some time to prepare 150 fields. But surely

you are only preparing once in a session? Perhaps you need to show us
what you are actually doing in your code...

>
> Helen
>

Tks Helen for the aportation, but the application have about 200 query
in diferents forms, if I create and prepare all the forms/querys may
be the aplication must start while prepare the coffe ... kidding.
No way.
Every form have some specific querys, some complex, but I tested and
REALLY the complexity its not a matter, if only take a fied from every
table, the prepare is so fast (less than a second).
But when 150.. things are very diferent.
Tip: If I disconect the tib_datasource from tib_query (for disconect
and isolate all edit fields in the form) the time its... pretty the
same... it's not depend of number of fields in the form, but the
fields fetched in the query.