- Narayana Bhat
- PowerBuilder
- Wednesday, 29 November 2017 07:51 AM UTC
Hi
I want to know performance related result for Commit command which we are using inside PowerBuilder and Backend is SQL Anywhere 16 & Isolation Level used 'RU'
1. If I use commit script for each row, what is the performance impact?
2. If I use commit script for batch of row, what is the performance impact?
In above 1 and 2, which one will give good performance?
Also
If I give datawindow.update() and not given commit, commit will be given batch of record [Isolation Level 'RU']. Will I get updated result back to my datawindow retrieve on Same transaction ?
Narayana Bhat
Find Questions by Tag
Helpful?
If a reply or comment is helpful for you, please don’t hesitate to click the Helpful button. This action is further confirmation of their invaluable contribution to the Appeon Community.