Jason Wharton wrote:

>> Actually, it turns out I was wrong. The aforementioned
>> collection of metadata seems to be an implicit operation that
>> takes place as soon as the very first statement is being
>> executed (after having established the connection). So I
>> encountered the same symptom, yet for a totally different reason...
>>
>> However, in my "real life" project it was the excessive use
>> of several TIB_StringProperties (ColumnAttributes,
>> FieldsDisplayFormats and FieldsDisplayLabels) that caused the
>> long preparation times. Too bad I can't use them the way I
>> intended to, but I guess I can cope with that! ;)
>
> To make sure I am clear, are you saying that heavy usage of the various
> properties of type TIB_StringList made the prepare much slower, so then you
> trimmed up your usage of them and things sped up?
>

It might be the old fetDomain search problem. The list has been into
this several times. I don't have the system available, but set the
property to search so that IBO does not search for Domain names in all
those stringlists. A hit is OK but for a miss it will do excessive
searching.

Regards,

/Dany