At 08:53 AM 14/04/2011, you wrote:

>>
>> It seems the performance problem is related to fetching all the records.
>> Were there some settings you did not move over from the TIBOQuery?
>
>Thanks for the idea! I found that the difference was FetchWholeRow. Once I turned that off, it resolved the problem!
>
>> You can setup horizontal dataset refinement by making use of the
>> OrderingItemLinks property. Search these archives for instructions of how to
>> do it.
>
>I just tried searching this Yahoo group for "OrderingItemLinks", and this email you just sent is the only one that comes up.

Maybe Jason was referring to the inter-related OrderingItems and OrderingLinks properties.

Helen