Subject | Re: [IBO] Query 3 times slower in 5.9 as compared with 4.21 |
---|---|
Author | Svein Erling Tysvær |
Post date | 2017-03-28T07:29:10Z |
>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