Subject | Performance Boost |
---|---|
Author | Marco Krause |
Post date | 2002-05-15T20:57:56Z |
Hello!
I'm just converting our applications from IBX to IBO and discovered
that my querys runs much more faster with a little modification in
TIB_Row.GetByName:
- GetByName knows the ColumnIndex from the last call and simply looks first
at lastColumnIndex+1. If this is not the right column, the complete column
list is searched...
One of my querys (table scan over 130000 records with 15 calls to IB_Cursor.FieldByName)
runs in 60 seconds. With the modification it tooks only 23 seconds!
Is this worth to implement?
--
Marco Krause
I'm just converting our applications from IBX to IBO and discovered
that my querys runs much more faster with a little modification in
TIB_Row.GetByName:
- GetByName knows the ColumnIndex from the last call and simply looks first
at lastColumnIndex+1. If this is not the right column, the complete column
list is searched...
One of my querys (table scan over 130000 records with 15 calls to IB_Cursor.FieldByName)
runs in 60 seconds. With the modification it tooks only 23 seconds!
Is this worth to implement?
--
Marco Krause