It seems that I have the same problem. see Thread ID:
799905 Did you find any solution?
>Has something changed in VFP8 that makes using the SQL UPDATE with optimistic table buffering slow unless a Tableupdate is performed after each update?
>
>I run this code in VFP7
>
>SET MULTILOCKS ON
>CURSORSETPROP("Buffering",5,'contdb')
>UPDATE contdb SET agent_lock = 0 WHERE idnum = 705999
>UPDATE contdb SET agent_lock = 0 WHERE idnum = 706000
>
>Both execute in fractions of a second, as they should. "idnum" is a fully indexed integer type primary key.
>
>Same code and data in VFP8 the first update runs quickly, not as fast as VFP7 but still less than a second. The second Update takes 60-80 seconds.
>
>In VFP8, if I put a tableupdate in after the first update the second one runs in less than a second.
>
>Anyone have any idea why this is?