Opportunistic locking has been shut off on the NAS for years. We just shut off SMB2 on the new Win 7 workstations.
We also went around and shut off oplocs on all the XP clients too. That's made a big difference in the number of corruptions, but still one a week or so The only corrupt tags I've seen have been on the tags used for the browse screens. I purchased a utility to quickly shut off the oplocks on the workstations rather that futzing with the registry on each one. I was speaking to the tech support of the company who wrote the utility and he was ranting on how much Windows 7 has wreaked havoc on his companies support, with people getting all kinds of trouble with SMB2. Is sounds like their product might be foxpro-based. ________________________________ From: Dave Crozier <[email protected]> To: ProFox Email List <[email protected]> Sent: Tuesday, May 15, 2012 6:30 AM Subject: RE: I have to be able to browse the whole database, but it causes corruption Although not VFP (it relates to Dataflex/Informix files) this is still relevant to VFP tables. http://www.dataaccess.com/whitepapers/opportunlockingreadcaching.html Dave -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Michael Madigan Sent: 14 May 2012 17:55 To: Pro Fox Email List Subject: I have to be able to browse the whole database, but it causes corruption I have to be able to browse the whole database. If I do it in vfp 9.0, it's been causing corruption. If I use a SQL select, the largest subset a user would use is about 26,000 records from 3 different tables, that takes about 30 seconds. . I was thinking of opening the database again with the noupdate clause, but will that guarantee me no corruption? Can you corrupt an index with a file opened noupdate? --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
