| Subject | RE: [IBO] Query 3 times slower in 5.9 as compared with 4.21 |
|---|---|
| Author | |
| Post date | 2017-04-07T14:17:56Z |
> There isn’t anything to fix where TIB_Cursor is concerned.
> When a component is inherently unidirectional it changes the behavior of things.
> Calling TIB_Cursor.Open merely opens the dataset cursor for fetching, but it doesn’t do a fetch
> so it starts at BOF.
> If you call the First method it will always close, if open, then reopen and fetch the first record for you.
>I realize this is different than how a buffered query works but I want each to work appropriately for
> what they specialize in.
> Hope this made sense
Jason:
Not really :-). It makes academic sense, but I don't get it--but I don't understand data access to the level you do nor do I want to. You have encouraged me and others to call .First and not .open. That .open will skip records on a closed cursor concerns me and I have to train my programmers that it is wrong on this one component to call .open, even though it is available. It leads to programming mistakes.
Ed Dressel