>>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.
George