Subject | Is there any difference between them |
---|---|
Author | James |
Post date | 2004-06-15T08:56:20Z |
Hi Experts!
Its been a year that I have been using and learning IBO. And learning
and using IBO is such a good thing. Can someone please tell me the
difference between these methods and which is the best?
What I want to accomplish is to commit the works done but leaving the
datasets open.
method 1.
with commitaction of the ib_dataset set to cainvalidatecursor
calling the ib_transaction.commit is it the same as ...
method 2.
with refreshaction of the ib_dataset set to rakeepdatapos
calling the ib_transaction.refresh(true) is it the same as ...
method 3
with commitaction of the ib_dataest set to carefresh
and refreshaction of the ib_dataset set to rakeepdatapos
calling the ib_trnsaction.commit is it the same as ...
method 4.
ib_transaction.commitretaining.
As far as I understand these 4 methods gives the same result. But
considering the performance, OAT, usage of system resources, and speed
which is the best to use under a condition where commiting a transaction
is done very often.(let say every minute?)
regards,
james
Its been a year that I have been using and learning IBO. And learning
and using IBO is such a good thing. Can someone please tell me the
difference between these methods and which is the best?
What I want to accomplish is to commit the works done but leaving the
datasets open.
method 1.
with commitaction of the ib_dataset set to cainvalidatecursor
calling the ib_transaction.commit is it the same as ...
method 2.
with refreshaction of the ib_dataset set to rakeepdatapos
calling the ib_transaction.refresh(true) is it the same as ...
method 3
with commitaction of the ib_dataest set to carefresh
and refreshaction of the ib_dataset set to rakeepdatapos
calling the ib_trnsaction.commit is it the same as ...
method 4.
ib_transaction.commitretaining.
As far as I understand these 4 methods gives the same result. But
considering the performance, OAT, usage of system resources, and speed
which is the best to use under a condition where commiting a transaction
is done very often.(let say every minute?)
regards,
james