Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Best settings to avoid locking conflict
Message
From
05/10/2005 11:03:26
 
General information
Forum:
Visual FoxPro
Category:
Installation, Setup and Configuration
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows Server 2003
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01055941
Message ID:
01056290
Views:
16
I meant 60 attempts as written.

SYS(3051, 1000) causes 1 second delay between attempts.
So there is 60 sec delay before reporting error. So in this case second and attempt numbers are same.

>Did you mean to use SET REPROCESS TO 60 SECONDS? The SET REPROCESS TO 60 sets reprocess to 60 attempts.
>
>>I have 80 users running application under W3K terminal server.
>>
>>Sometimes LOCK() function fails or REPLACE command returns error
>>"Record is in use by another user".
>>
>>To fix this I will try to use following settings in each datasession init:
>>
>>
SET LOCK OFF
>>SYS(3051, 1000) &&  Set Lock Retry Interval
>>SYS(3052, 1, .t. )  && Overrride set reprocess locking
>>SYS(3052, 2, .t. )
>>* This causes 60 seconds delay before reporting error:
>>SET REPROCESS TO 60
>>SET REPROCESS TO 60 SYSTEM
>>
>>Are those best valuest ?
>>Are there any other VFP9 or W3K server config parameters which can be changed?
Andrus
Previous
Reply
Map
View

Click here to load this message in the networking platform