Subject Re: [IBO] Query 3 times slower in 5.9 as compared with 4.21
Author Svein Erling Tysvær
>When some sqls  do not return data (ie zero records)  the 
>
>eof = false, 
>bof = true  and
>recordcount = 0

I remember Jason many years ago saying that with IB_Cursors, you should call "First" and not "Open". He also said that once a cursor reach eof it is closed, so closing a cursor that has eof = true isn't necessary. Queries on the other hand, can move forwards and backwards, should use "Open" and ought to be explicitly closed. Do you still get the same result if you change your IB_Cursor to using "First" and not "Open"?

HTH,
Set