Subject So slooooooooooooooooow prepare
Author skander_sp
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.

Any opinion? solution? similar problem? workaround?

Tks
Skander