Subject | Re: [IBO] Performance Boost |
---|---|
Author | Jason Wharton |
Post date | 2002-05-15T22:11:37Z |
Sure, send me the changes and I'll merge them in.
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com
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