Subject | Re: [IBO] Performance Boost |
---|---|
Author | jason1 |
Post date | 2002-05-25T00:01:19Z |
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
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/
>
>
>