Subject | So slooooooooooooooooow prepare |
---|---|
Author | skander_sp |
Post date | 2008-10-29T08:22:30Z |
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
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