On 3/16/2012 4:45 PM, Paul Hill wrote: > On Fri, Mar 16, 2012 at 8:25 PM, M Jarvis<[email protected]> wrote: >> On Fri, Mar 16, 2012 at 1:21 PM, MB Software Solutions, LLC >> <[email protected]> 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. >
I'm just running tons of queries on SPT cursors....no updates. My performance test didn't really yield a noticeable difference...perhaps because it was just queries. Hmm. Still, you confirmed what I had heard (in an updating context). Thanks all! -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 _______________________________________________ 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.
