Hello Jason!

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

Yes, that's exactly what I was trying to say. (Apologies for clumsy wording, it's not my language.)

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

I was referring to the TIBODataBase. Right now it takes about 90 ticks to prepare my TIBOQuery. If I put this single line into the TIBODataBase.ColumnAttributes property (while FieldsEntryType = []):

DO_BOOLEAN=BOOLEAN=J,N

...the same query needs about 250 ticks for preparing.


Kind regards
Thomas