>>>Hi. I have a VFP 5 Order Entry app. that uses optimistic buffering. Works well except when there are multiple users, where saving an order is very slow. A trace shows that it sits on the TABLEUPDATE(.T.) for upto 30 seconds. Any ideas.
>>>
>>>TIA.
>>
>>How many records you're updating at once? Do you have triggers (RI) on your tables?
>
>Usually 1 Order and about 5 items. No triggers, etc. Thanks.
May be there are some field/table rules? Anyway, it sounds too slow and I guess, there is either virus or Anitvirus making this slow. What is the exact code in Save button?
If it's not broken, fix it until it is.
My Blog