Subject | RE: [IBO] CalculateField being called too often |
---|---|
Author | Support List |
Post date | 2011-04-14T15:14:46Z |
Joe,
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.
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
> > It seems the performance problem is related to fetching all the records.Fantastic!
> > 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!
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 theSorry for the retarded advice.
> > 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.
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