Subject | Re: [IBO] IB_Connection.Params and prepare-Speed |
---|---|
Author | Jason Wharton |
Post date | 2001-07-31T05:21:07Z |
Try a quick experiment in the code.
In the IBA_Connection.IMP file put a line of code for each of the
stringlists created setting sorted to true.
I believe if they are sorted then it will use the binary search when looking
up property values.
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com
In the IBA_Connection.IMP file put a line of code for each of the
stringlists created setting sorted to true.
I believe if they are sorted then it will use the binary search when looking
up property values.
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com
----- Original Message -----
From: <guido.klapperich@...>
To: <IBObjects@yahoogroups.com>
Sent: Monday, July 30, 2001 10:24 PM
Subject: Re: [IBO] IB_Connection.Params and prepare-Speed
> > 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
>
>
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>