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
Yes error handling is necessary and also if update fails rollback also necessary
Narayana
Example: In a "project planning app" I see a myriad of tasks on screen. I selected 20 of these tasks, then drag-and-drop an avatar onto one of them to assign these tasks to the avatar's person. I want such drag-and-drop to either succeed 100% or fail completely.
HTH /Michael