Hello James,

> setting the autofetchall to neither true or false doesn't affect the
> performance. I have try running the sql statement in ib expert, the
> result is very fast. And I try it alson on IB_SQL, the result is very
> fast to. Please help me with this thanks in advance.

OK, it would seem that the sql is not a major factor.

So your next steps could be:-

1) Check OnCalculateField events.
2) Check BeforeScroll and AfterScroll events.

Easy to comment out any executed code and see if any
speed difference.

3) Disconnect ANY detail (slave) queries and see if
there is any speed difference.

hth,
William.