Subject Re: [IBO] Reduce traffic over network
Author Adrian Wreyford
Thanks Jason,

My ordering Items and Links were in place. All I did was set FetchWholeRows = False as you recommended, with almost instantaneous results, no longer the status message informing that the query is still fetching data. LOTS!!!!! less traffic over the network!!

Jason recommended:

You can use the FetchWholeRows = false property in conjunction with the
OrderingItems and OrderingLinks properties to set this up such that IBO will
refine what records are brought to the client along the lines you are
looking for. This is called dataset refinement. It optimizes things based on
navigational commands such as First and Last as well as Locate() when search
criteria is the same as the OrderingLink columns being used.

Please search the archives on these various topics as much has already been

[Non-text portions of this message have been removed]