Joe,

> > 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!

Fantastic!

This also explains why your calculated fields were being hit so hard.

You are using vertical dataset refinement instead of horizontal.
You could be using both and you might get yet another performance boost.

> > 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.

Sorry for the retarded advice.

There are two properties.

OrderingItems and OrderingLinks

If you configure them correctly you can take advantage of the feature I was
referring to.

Regards,
Jason Wharton