Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
TABLEUPDATE slow
Message
From
11/07/2006 02:22:36
 
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Environment versions
Visual FoxPro:
VFP 5
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01135188
Message ID:
01135209
Views:
10
>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.

try, but vfp should already do it
...
IF FLOCK() && implement a WAIT FOR TIMEOUT loop
  TABLEUPDATE(.T.)
  UNLOCK
ENDIF
Previous
Reply
Map
View

Click here to load this message in the networking platform