Subject Re: [IBO] IB_Connection.Params and prepare-Speed
Author guido.klapperich@t-online.de
> Are you saying that you have a bunch of property settings at the
> TIB_Connection level and that this is causing things to be slow?
>

Yes

>
> I believe this could definitely cause a performance problem. I have never
> had more than a dozen entries so this is a blind spot. I typically use
> domains there which serve to store entries for many columns at a time.
>

Me too, but such things like FieldsDisplayLabel or FieldsDisplayWidth cannot be
used with domains. And in FieldsDisplayLabel and -Width I have up to 300 items
for each and this causes the performance problem.

>
> I'll bet we can flip those lists to sorted and then you will get a binary
> search instead of a brute one. This should speed things up a lot. I'll log
> this as a bug and look into doing this.
>

This would be great


Guido