Community
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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Correlation between COMMIT WORK and Performance of a program-report

Former Member

‎2008 Feb 04 12:36 PM

0 Likes
395

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.

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.

Reply
1 REPLY 1
Read only

Former Member

‎2008 Feb 04 12:44 PM

0 Likes
369

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