Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Correlation between COMMIT WORK and Performance of a program-report

Former Member
0 Kudos
56

Hi all,

Is there any relation between commit work and performance.

Is it useful to use commit work (or COMMIT WORK AND WAIT)to increase performance?

Thanks.

1 REPLY 1

Former Member
0 Kudos
30

I would say, that COMMIT WORK decreases the performance of a program, because programs usually act within memory and COMMIT WORK stores data to the database, which means, that at least some additional network traffic is produced...