Application Development and Automation 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: 
Read only

Correlation between COMMIT WORK and Performance of a program-report

Former Member
0 Likes
337

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
Read only

Former Member
0 Likes
311

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...