Subject Re: [IBO] POS attribute
Author Helen Borrie
At 12:51 AM 02-11-01 +0100, you wrote:
>I have done a test. Without the POS-attribute the locate takes 6 sec and with
>the POS-attribute 6 sec, as well. Have I missed something or exist another way
>to speed up the locate-method ?
>BTW, for what is the ITEM-attribute ?

Guido,
It's the keyword. In an OrderingLink of MYCOL=ITEM=1;POS=0
the ITEM keyword says MYCOL identifies the OrderingItem, the POS keyword (if not 0) indicates the position where the search should stop incrementing the search string.

regards,
Helen




>Guido
>
>Jason Wharton wrote:
>
> > > Can you please tell me, how to use the POS-attribute to speed up the
> > > locate-method. Or tell me, where in the help is anything written about it.
> >
> > If you are aware of it, that's about all you need to know. What is said of
> > the horizontal dataset refinement behavior tells you everything else you
> > need to know.
> >
> > You simply add it as an attribute to your ordering links entries.
> >
> > I recommend that you always use POS=0 which simply turns the feature on. You
> > can go greater than zero if you want refinement to occur on an nth character
> > when incremental searching. This is the only other area where a POS greater
> > than 0 should be considered.
> >
> > Regards,
> > Jason Wharton
> > CPS - Mesa AZ
> > http://www.ibobjects.com
> >
> >
> > ___________________________________________________________________________
> > IB Objects - direct, complete, custom connectivity to Firebird or InterBase
> > without the need for BDE, ODBC or any other layer.
> > ___________________________________________________________________________
> > http://www.ibobjects.com - your IBO community resource for Tech Info papers,
> > keyword-searchable FAQ, community code contributions and more !
> >
> > Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>___________________________________________________________________________
>IB Objects - direct, complete, custom connectivity to Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
>___________________________________________________________________________
>http://www.ibobjects.com - your IBO community resource for Tech Info papers,
>keyword-searchable FAQ, community code contributions and more !
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

All for Open and Open for All
InterBase Developer Initiative ยท http://www.interbase2000.org
_______________________________________________________