>>>>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?
I do not use any RI, constraints, triggers etc.
I took a copy of the client's data home and it runs fine. I will disable the antivirus and see if that makes a difference.
George