Subject | DataSetProvider, ClientDataSet performance |
---|---|
Author | gtsglenn |
Post date | 2004-07-09T04:53:09Z |
I am having a performance issue of tryng to fill a ClientDataSet
using a DataSetProvider using IB Objects.
Compare the following:
Drop a TIB_Connection, a TIB_Transaction and a TIBOQuery. Set the
SQL for the TIBOQuery and connect it up to the TIB_Connection & the
TIB_Transaction.
Now drop a TDataSetProvider and TClientDataSet. Connect the
TDataSetProvider up to the TIBOQuery and then set the
TClientDataSet's provider to be the TDataSetProvider. Then Set the
Active property of the TClientDataSet to true.
You will see (or at least I do) that the command takes quite a long
time to be downloaded.
Try the same thing with the TIBDatabase, TIBTransaction & TIBQuery
that come with Delphi and you will see the performance difference.
Does anyone know why this occurs. I would like to use IB Objects,
but this is almost a showstopper.
Cheers,
Glenn
using a DataSetProvider using IB Objects.
Compare the following:
Drop a TIB_Connection, a TIB_Transaction and a TIBOQuery. Set the
SQL for the TIBOQuery and connect it up to the TIB_Connection & the
TIB_Transaction.
Now drop a TDataSetProvider and TClientDataSet. Connect the
TDataSetProvider up to the TIBOQuery and then set the
TClientDataSet's provider to be the TDataSetProvider. Then Set the
Active property of the TClientDataSet to true.
You will see (or at least I do) that the command takes quite a long
time to be downloaded.
Try the same thing with the TIBDatabase, TIBTransaction & TIBQuery
that come with Delphi and you will see the performance difference.
Does anyone know why this occurs. I would like to use IB Objects,
but this is almost a showstopper.
Cheers,
Glenn