Isn't it the other way around? VFP implicitly does a USE...EXCLUSIVE which locks all files and you lose all the overhead associated with sharing access.
-- rk -----Original Message----- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Paul Hill Sent: Friday, March 16, 2012 4:46 PM To: profoxt...@leafe.com Subject: Re: SET EXCLUSIVE -- faster processing? On Fri, Mar 16, 2012 at 8:25 PM, M Jarvis <brewda...@gmail.com> wrote: > On Fri, Mar 16, 2012 at 1:21 PM, MB Software Solutions, LLC > <mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote: >> If you're running something local (not on the network but your own >> local drive), does using SET EXCLUSIVE ON improve the performance >> enough (if at all) to notice? I thought I had heard that rumor years ago. > > In my experience, it can make a BIG difference.... HUGE difference. Fox doesn't need to lock the dbf or cdx when doing updates. -- Paul _______________________________________________ Post Messages to: ProFox@leafe.com 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/DF1EEF11E586A64FB54A97F22A8BD0441D50E3A472@ACKBWDDQH1.artfact.local ** 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.