Subject | Re: [IBO] Replacement components |
---|---|
Author | Svein Erling Tysvaer |
Post date | 2006-10-31T17:15:26Z |
Hi again, Niegil!
You're moving from the BDE and Paradox to IBO and Firebird. If you had
been moving from the BDE with Firebird to IBO with Firebird, it might
have been worth considering just switching components (though some
people have found it better to redesign everything), but changing
Paradox to Firebird means that things behave completely differently,
I'll take an example. Counting records is a very quick operation in
Paradox, it can even store the number of records in the table itself.
Firebird has to actually check every record, see if the current version
of the record is visible to the current transaction and if not it may
have to check earlier versions of the same record. So a subsecond
question in Paradox may take several minutes in Firebird (if the
database is huge). Other things are the opposite way, Firebird is far
quicker.
I recommend you to start from scratch using TIB_Connection,
TIB_Transaction (that's a new consept for you), TIB_Cursor, TIB_Query,
TIB_DSQL, possibly TIB_Script and other components as you need them.
Stay away from TIBOTable and stop thinking in terms of tables (that is a
shift in mindset, IBO does a good job with TIBOTables, making them
behave reasonably decently even though the idea is bad in Firebird).
Set
niegil_firebirddev wrote:
You're moving from the BDE and Paradox to IBO and Firebird. If you had
been moving from the BDE with Firebird to IBO with Firebird, it might
have been worth considering just switching components (though some
people have found it better to redesign everything), but changing
Paradox to Firebird means that things behave completely differently,
I'll take an example. Counting records is a very quick operation in
Paradox, it can even store the number of records in the table itself.
Firebird has to actually check every record, see if the current version
of the record is visible to the current transaction and if not it may
have to check earlier versions of the same record. So a subsecond
question in Paradox may take several minutes in Firebird (if the
database is huge). Other things are the opposite way, Firebird is far
quicker.
I recommend you to start from scratch using TIB_Connection,
TIB_Transaction (that's a new consept for you), TIB_Cursor, TIB_Query,
TIB_DSQL, possibly TIB_Script and other components as you need them.
Stay away from TIBOTable and stop thinking in terms of tables (that is a
shift in mindset, IBO does a good job with TIBOTables, making them
behave reasonably decently even though the idea is bad in Firebird).
Set
niegil_firebirddev wrote:
> Hi All,
>
> I have planned to use IBO for connecting to database . The existing
> application have the following components
>
> TDatasource
> TTable
> TDatabase
> TBatchMove
> TQuery
>
> can anybody pls tell the corresponding IBO Components that i should use.
>
>
> Regards
>
> Niegil T