1.
2. Oplocks:
A. NT:
i. UseOpportunisticLocking should be 0
ii. EnableOplocks should be 0
iii. The rest don't matter
B. Win2K/XP:
i. OplocksDisabled should be 1
ii. EnableOplocks should be 0
iii. The rest don't matter
C. Win9x: Control Panel, System applet, Performance tab, File System button, Troubleshooting tab, CHECK the boxes labeled:
i. "Disable new file sharing and locking semantics."
ii. "Disable write-behind caching for all drives."
iii. On the Hard Disk tab, you may wish to try setting Read-ahead optimization to None, but I think that should only make a difference on the server machine.
3. N/A
4. LOCALSHARE (BDE, Configuration tab, Configuration > System > INIT) must be set to TRUE for all users.
5. Disk caching on Win2K (presumably XP, but I can't check that):
Properties for the drive, Hardware tab, select the disk of interest, click the Properties button, on the Disk Properties tab, UNcheck the "Write cache enabled" box if it'll let you.
6. Make sure the machine serving the .DB files isn't being used as a workstation.
Tony McGuire
"It's not about having enough time. It's about priorities.