> 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?

Were these used at the TIB_Dataset level or were you using them at the
TIB_Connection level?

Thanks,
Jason