CODEWITHSUNDEEP
delphifirebird
Marco Andreolli
Marco Andreolli

Reputation: 376

Avoid too long active transaction with IBX components

My question is very simple, what is the best practice to avoid to have too long active transaction with an application that use many component TIBDataSet? I would avoid to have very old OAT and than have very bad performance

My application have more dataset that must be always opened (until the application is running). I would avoid to close and reopen the transaction because I will be reopen all dataset.

I must be replace this component?
And if yes, what is the best choice?
ClientDataSet with DataSetProvider or switch to IBO component (also If I wouldn't install other component on my IDE)

Upvotes: 2

Views: 332

Answers (1)

Andrej Kirejeŭ
Andrej Kirejeŭ

Reputation: 5491

Read-only transactions don't affect performance of FB server. In our project we use single projectwide read-only always open transaction for data fetching and multiple short living transactions for data modification.

We use modified IBX components where second separate transaction for data reading was added.

Upvotes: 1

Related Questions