Subject Re: [IBO] Performance Boost
Author Jason Wharton
Sure, send me the changes and I'll merge them in.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com


----- Original Message -----
From: "Marco Krause" <mkrause@...>
To: <IBObjects@yahoogroups.com>
Sent: Wednesday, May 15, 2002 1:57 PM
Subject: [IBO] Performance Boost


> 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