>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?
If it's not broken, fix it until it is.
My Blog