>I am curious about exactly when a row gets locked and when the table header gets locked under the follwing conditions:
>
>1 - Buffering set to 'Optimistic Row'
>2 - Many new rows appended to table
>3 - Begin transaction
>4 - Tableupdate
>5 - End transaction
>
>Thanks in advance for your help
>
Andy Kramek says rarely (if ever) do you need to use Row buffering. Table buffering gives you complete control.
http://weblogs.foxite.com/andykramek/archive/2005/10/18/948.aspx