Subject | Switching From TIBOTable to TIBOQuery |
---|---|
Author | jackmason7 |
Post date | 2008-11-15T23:02:58Z |
For several years we have been urged to convert from TIBOTables to
TIBOQuerys for our application. In our application, there are almost
no instances where we simply open a table for viewing. Almost always,
it is updated.
We have converted quite a few of our TIBOTables without incident, but
in one area after we do 20 to 25 updates, the program begins slowing
down dramatically to the extent that a single update requires over 5
minutes to complete. Once it begins slowing down, it slows down very
rapidly.
Breaking the execution reveals the IBO code is processing or checking
"bookmarks". Is there a way to either turn off all bookmark
processing or do something that eliminates this extensive checking?
Whatever it is we have done, when we substitute a TIBOTable for the
TIBOQuery in this area of the code, it also processes "bookmarks" even
though the documentation we can find on bookmarks indicates they are
only applicable to TIB_Query, which we are not using.
Help?
TIBOQuerys for our application. In our application, there are almost
no instances where we simply open a table for viewing. Almost always,
it is updated.
We have converted quite a few of our TIBOTables without incident, but
in one area after we do 20 to 25 updates, the program begins slowing
down dramatically to the extent that a single update requires over 5
minutes to complete. Once it begins slowing down, it slows down very
rapidly.
Breaking the execution reveals the IBO code is processing or checking
"bookmarks". Is there a way to either turn off all bookmark
processing or do something that eliminates this extensive checking?
Whatever it is we have done, when we substitute a TIBOTable for the
TIBOQuery in this area of the code, it also processes "bookmarks" even
though the documentation we can find on bookmarks indicates they are
only applicable to TIB_Query, which we are not using.
Help?