> 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. My next step would be just to put the SQL into a new
query and try it out using the Designer. This is the same
window as IB_SQL, so should be just as fast!

Then put in the other bits till you hit a problem.

Sometimes bits just get carried over that are not needed,
and a clean start helps ;)

(Delphi or Builder? )

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services