Re: SET EXCLUSIVE -- faster processing?

2012-03-16 Thread Michael Madigan
Is record processing with a database opened with  "Use database exclusive" different if you SET EXCLUSIVE ON too?    - Original Message - From: "MB Software Solutions, LLC" To: ProFox Email List Cc: Sent: Friday, March 16, 2012 5:32 PM Subject: Re: SET EXCLUSIVE

Re: SET EXCLUSIVE -- faster processing?

2012-03-16 Thread MB Software Solutions, LLC
On 3/16/2012 5:16 PM, Sytze de Boer wrote: > 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 !! Again, these are READ-ONLY (query) operations I'm

Re: SET EXCLUSIVE -- faster processing?

2012-03-16 Thread Sytze de Boer
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 < mbsoftwaresoluti...@mbsoftwares

Re: SET EXCLUSIVE -- faster processing?

2012-03-16 Thread MB Software Solutions, LLC
On 3/16/2012 4:45 PM, Paul Hill wrote: > On Fri, Mar 16, 2012 at 8:25 PM, M Jarvis wrote: >> On Fri, Mar 16, 2012 at 1:21 PM, MB Software Solutions, LLC >> wrote: >>> If you're running something local (not on the network but your own local >>> drive), does using SET EXCLUSIVE ON improve the perf

RE: SET EXCLUSIVE -- faster processing?

2012-03-16 Thread Richard Kaye
riday, 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 wrote: > On Fri, Mar 16, 2012 at 1:21 PM, MB Software Solutions, LLC > wrote: >> If you're running something local (not on th

Re: SET EXCLUSIVE -- faster processing?

2012-03-16 Thread Paul Hill
On Fri, Mar 16, 2012 at 8:25 PM, M Jarvis wrote: > On Fri, Mar 16, 2012 at 1:21 PM, MB Software Solutions, LLC > 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 th

Re: SET EXCLUSIVE -- faster processing?

2012-03-16 Thread M Jarvis
On Fri, Mar 16, 2012 at 1:21 PM, MB Software Solutions, LLC 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. > > tia, > --Mike

SET EXCLUSIVE -- faster processing?

2012-03-16 Thread MB Software Solutions, LLC
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. tia, --Mike -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software