In most of my apps, I have a routine to reindex all data, pack all data etc (Exlusive use is required to do this)
I've just tested this and by setting exclusive off It makes a huge difference !! S On Sat, Mar 17, 2012 at 10:11 AM, MB Software Solutions, LLC < [email protected]> wrote: > 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 > [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/CAG1nNy-su7raE5P4frVx3h1=Cgx+1k3WzW-G=SYEH1i=bt4...@mail.gmail.com ** 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.
