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