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?

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.

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.

Regards,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: <guido.klapperich@...>
To: "IBObjects" <IBObjects@yahoogroups.com>
Sent: Monday, July 30, 2001 9:22 PM
Subject: [IBO] IB_Connection.Params and prepare-Speed


> In my application I have enormous problems with the prepare-speed of my
> queries. Now I have found out, that reason for my problems is the
> IB_Connection. In my ib_connection most of the Fields...-Properties are
> filled with up 300 items. When I take a new ib_connection without any
> Fields...-Properties, the prepare-time will speed up. Here some
> time-measurements:
> prepare-time:
> old-connection: 2,8453 sec
> new-connection: 0,39845 sec
> Exist there a solution for the problem ?
>
>
> Guido
>
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>