Subject Re: [IBO] Performance Boost
Author jason1
Hallo,

Hier Sita aus Luxemburg und möchten gern wissen welche version
sie benutzten und ob wir diese Anderung auch in der
version 3.6_Di machen können um die performance zu steigern.

Danke Im voraus
Sita Vincenzo
Sita Software

----- Original Message -----
From: "Marco Krause" <mkrause@...>
To: <IBObjects@yahoogroups.com>
Sent: Wednesday, May 15, 2002 10: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
>
>
>
>
>
>
___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or
InterBase
> without the need for BDE, ODBC or any other layer.
>
___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info
papers,
> keyword-searchable FAQ, community code contributions and more !
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>