Subject Re: [IBO] Locate and the POS-attribute
Author Jason Wharton
> Some days ago, Jason told me, that the POS-attribute can speed up the
> locate-method. I have made some tests and here are the results:
> I have a customers-dataset with nearly 7000 records and this dataset is
> ordered by customer-nr. I do a locate on the customer-name (remember,
> that the dataset is not ordered by the customer-name) and I want to find
> a customer, which is the last one in the dataset. I simulate a slow
> network connection by copying some big files over the network, while I
> do the locate.
> The locate without the POS-attribute takes 51,5 seconds
> The locate with the POS-attribute takes 1,5 seconds
> !!!!!!!!!!!!!!!!!!!!!
> Wow, this is really great, Jason. I don't know how you are doing this,
> but it's magic.
> I had a lot of problems with a slow network at my customer and then
> comes IBO4 and all problems are solved. Thanks Jason.
> BTW, I think you should really mention this great feature in your
> help-file, there is nothing written about it.

Thanks for drawing attention to this.

It isn't magic, it is just careful planning of a good architecture that
allows me to do some great things.

This is the very capability I had in mind when I started this 5 years ago.
It is most gratifying to see it enjoyed by others.

I agree that I need to better document it.

PS. If you use TIBOTable you get this behavior automatically. If you are
using small lookup tables that all records will be in the buffer then it is
best to avoid this feature by setting AutoFetchAll to true.

Jason Wharton
CPS - Mesa AZ